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

转载于:https://www.cnblogs.com/DylanZ/p/10528895.html