统计SQL数据库中每个表的行数记录数

chixm

SELECT  OBJECT_NAME(ii.id) TableName ,  rows
FROM    sysindexes ii
INNER JOIN sysobjects oo
ON ( oo.id = ii.id
     AND oo.xtype = 'U ')
WHERE   ii.indid < 2
ORDER BY rows desc ;