查询数据库中所有不为空的表,并返回相应表名称、行数
如何查询数据库中所有不为空的表,并返回相应表名称、行数
SELECT
A.NAME,
MaxRows = MAX(B.rows)
FROM sys.tables A
INNER JOIN sys.partitions B
ON A.object_id = B.object_id
WHERE B.rows > 0
--and name not like 'ACT_%'
--and name not like 't_s_%'
GROUP BY A.name
ORDER BY name,MAX(B.rows) DESC