/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

4 votes160 views3 answers
Drop Table Oracle
SQL
0 vote139 views1 answer
Mql5 list all available symbols
SQL
0 vote157 views1 answer
Interview experience as a call?
SQL
3 votes143 views2 answers
Oracle grants
SQL
0 vote146 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote135 views1 answer
Mysql sql select one day before
SQL
14 votes152 views2 answers
Install mysqldump
SQL
0 vote151 views1 answer
Implicit inner join table alias with id values
SQL
0 vote153 views2 answers
Plan d'exécution requete oracle autotracer
SQL
3 votes148 views4 answers
Psql list tables in schema
SQL