如何查询数据库中所有不为空的表，并返回相应表名称、行数。

[c953131]

如何查询数据库中所有不为空的表，并返回相应表名称、行数。

[KeepSayingNo]

应该是

select distinct object_name(id) from sys.sysindexes where rows>0 

[Shawn]

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
GROUP BY A.name
ORDER BY MAX(B.rows) DESC

[Shawn]

--这个row数量不会太实时。想精确，就得循环SELECT COUNT(*) FROM TABLENAME的方式。没效率

SELECT 
	A.NAME,
	MaxRows = MAX(B.rows)
FROM sys.tables A
	INNER JOIN sys.partitions B
		ON A.object_id = B.object_id
GROUP BY A.name
ORDER BY MAX(B.rows) DESC

[rubynle]

select distinct object_name(id) from sys.sysindexes where rowcount>1

[rubynle]

是rowcount>0

[rubynle]

靠，老写错，rowcnt>0