本文主要是介绍使用sql语句获取SQL server库里所有表的表名,注释,行数,希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
select * from (SELECT
t.name,schema_id,
SCHEMA_NAME(schema_id)+'.'+t.name AS 表名,
c.value AS 注释
FROM
sys.tables AS t
LEFT JOIN
sys.extended_properties AS c
ON c.major_id = t.object_id AND c.minor_id = 0 AND c.name = 'MS_Description'
) ss
left join ( SELECT OBJECT_NAME(p.object_id) AS [表名], SUM(p.rows) AS [行数]
FROM sys.partitions p WHERE p.index_id < 2
AND OBJECT_NAME(p.object_id) IS NOT NULL
GROUP BY p.object_id) aa
on ss.name = aa.[表名]
order by SCHEMA_NAME(schema_id)+'.'+ name
这篇关于使用sql语句获取SQL server库里所有表的表名,注释,行数的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!