SQL Server 查询数据库中所有的表名及行数

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
            )
        )
ORDER BY a.NAME
    ,b.rows DESC

作者：jiankunking 出处：http://blog.csdn.net/jiankunking