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