查询所有表的记录数SQLServer

Posted on 2014-07-14 08:31  南岗V哥  阅读(150)  评论(0)  编辑  收藏  举报

SELECT object_name (i.id) TableName,   
       rows as RowCnt   
FROM sysindexes i   
INNER JOIN sysObjects o   
    ON (o.id = i.id AND o.xType = 'U ')   
WHERE indid < 2   
ORDER BY RowCnt desc,TableName