获取每个表的记录数？

Question

我有 700 个表，我想使用 dbvisualizer 了解每个表的记录数。

怎样才能做到既简单又有效呢？帮我。

Answer 1

试试这个：

SELECT SUM(TABLE_ROWS) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '{database}';

Answer 2

SELECT  distinct t.name, p.rows
FROM    sys.tables AS t
INNER JOIN sys.partitions AS p
        ON t.object_id = p.object_id
ORDER BY t.name