获取每个表的记录数？

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