/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 vote184 views1 answer
Postgresql find missing id
SQL
-1 vote186 views1 answer
Extract Data from SQL Server into XML Format
SQL
50 votes265 views6 answers
Sql duplicate rows
SQL
3 votes188 views1 answer
Oracle user quota unlimited
SQL
-1 vote179 views1 answer
Plsql while
SQL
0 vote232 views1 answer
Count number of entires by months sql
SQL
8 votes200 views2 answers
Safe update mode in mysql
SQL
2 votes192 views1 answer
Get first 2 letter in sql
SQL
0 vote199 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote195 views2 answers
Alter table add multiple columns mysql
SQL