mssqlserver获取表说明和行数

SELECT a.*,t.rows FROM (SELECT a.name AS 表名, isnull(g.[value],'-') AS 说明 FROM sys.tables a left join sys.extended_properties g ON (a.object_id = g.major_id AND g.minor_id = 0) ) AS aleft join (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)) ) AS t ON a.表名=t.name