SELECT a.name TableName,b.rows TotalCount,D.Description AS [Description]
FROM
sysobjects a
INNER JOIN sysindexes b ON a.id=b.id
join
(
select a.name AS name,isnull(g.[value], ‘未定义’) AS Description
from sys.tables a left join (SELECT * FROM sys.extended_properties WHERE NAME=‘Description’ ) g on (a.object_id = g.major_id AND g.minor_id = 0)
) D
ON D.name = A.name
WHERE b.indid IN(0,1) AND a.Type=‘U’ and a.name not in (’’)
ORDER BY b.rows desc