/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 vote98 views1 answer
Error code 1241 mysql
SQL
2 votes111 views2 answers
Mamp connect mysql terminal
SQL
0 vote112 views1 answer
How to connect to xampp sql server on windows cmd
SQL
1 vote100 views1 answer
PLS-00225 type
SQL
2 votes103 views2 answers
Oracle multiple insert
SQL
0 vote113 views1 answer
Sql query to find percentage of null values in a table
SQL
1 vote126 views1 answer
Oracle select row max date
SQL
1 vote112 views1 answer
Quit mysql
SQL
2 votes103 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote107 views2 answers
Get item by composite primary key mysql
SQL