/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 vote192 views1 answer
Copying query result to excel
SQL
0 vote303 views1 answer
Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'
SQL
7 votes193 views4 answers
How to reset the identity column in sql server
SQL
0 vote182 views1 answer
Console output pl sql
SQL
2 votes257 views1 answer
Mysql now format
SQL
0 vote229 views1 answer
Combine 2 columns search query mysql
SQL
2 votes208 views1 answer
Mysql cannot delete or update a parent row
SQL
1 vote190 views1 answer
SQLite order random
SQL
0 vote218 views1 answer
Edit shchima table in sql
SQL
0 vote218 views1 answer
Login failed for user sql server
SQL