Get record count of each table?

Question

I have 700 tables, and I want to know the record count of each table using dbvisualizer.

How can do simply and effective? Help me.

Answer 1

Try this:

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