SQL SERVER查询所有表、表注释、行数、字段、字段注释

1、查询所有表

select * from sys.tables where type='U'

2、查询所有表及其行数

SELECT a.name, b.rows
FROM sysobjects AS a INNER JOIN sysindexes AS b ON a.id = b.id
WHERE (a.type = 'u') AND (b.indid IN (0, 1))
ORDER BY b.rows DESC

3、查询表注释

select a.name ,c.value
from sys.tables a left join sys.extended_properties c on c.major_id = a.object_id

4、查询所有字段

select * from sys.columns

5、查询字段注释

select a.name as table_name,
        b.name as colunm_name,
        c.value as colunm_description
from sys.tables a left join sys.columns b on a.object_id=b.object_id
left join sys.extended_properties c on b.object_id=c.major_id and b.column_id=c.minor_id
where a.type='U'