/SQL/SQL query to get all table records count from a database

SQL query to get all table records count from a database

DECLARE @TableRowCounts TABLE ([TableName] VARCHAR(128), [RowCount] INT) ;
INSERT INTO @TableRowCounts ([TableName], [RowCount])
EXEC sp_MSforeachtable 'SELECT ''?'' [TableName], COUNT(*) [RowCount] FROM ?' ;
SELECT [TableName], [RowCount]
FROM @TableRowCounts
ORDER BY [TableName]
GO

Source: mssqltips.com

Similar codes

1 vote238 views1 answer
Mysql show database size in mb
SQL
0 vote320 views1 answer
Sqlite display data in separated columns
SQL
0 vote185 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote171 views3 answers
Mysql connection string
SQL
0 vote181 views1 answer
Mysql query with sql to get the next row
SQL
0 vote177 views1 answer
New rails app with mysql
SQL
1 vote164 views1 answer
Oracle truncate partition
SQL
3 votes173 views2 answers
Mysql HAVING
SQL
-1 vote177 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
0 vote199 views1 answer
How to drop a trigger in postgresql
SQL