/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

37 votes190 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
5 votes143 views2 answers
Sql number columns
SQL
3 votes175 views2 answers
How to force truncate a table in mysql
SQL
6 votes162 views3 answers
Check if string contains substring sql
SQL
0 vote154 views1 answer
Ajax error exception handeling
SQL
0 vote152 views1 answer
Sauvegarde complète my sql
SQL
0 vote142 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote152 views1 answer
Mysql multiple primary keys
SQL
1 vote154 views3 answers
How to get date in sql
SQL
0 vote158 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL