SqlServer查数据表的记录数

查每一张表的记录数（按记录数排序）： SELECT t.NAME AS 表名, SUM(p.rows) AS 记录数 FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID = i.object_id INNER JOIN sys.part