/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

0 vote247 views1 answer
IS THEre any difference between using default and := in plsql
SQL
1 vote257 views1 answer
Cannot drop database because it is currently in use
SQL
1 vote257 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
-1 vote182 views3 answers
Error mysql shutdown unexpectedly
SQL
1 vote173 views1 answer
Set id count mysql
SQL
1 vote197 views1 answer
How to see all table partition in oracle
SQL
1 vote198 views1 answer
Oracle create index if not exists
SQL
5 votes229 views3 answers
Sql limit offset
SQL
0 vote191 views4 answers
Change schema in sql server
SQL
0 vote185 views1 answer
Sql if else in select
SQL