/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 vote260 views1 answer
Sql right characters
SQL
1 vote249 views1 answer
Psql show with user is logged in
SQL
0 vote463 views1 answer
Multiple row join
SQL
0 vote228 views1 answer
Postgresql add leading zeros
SQL
0 vote308 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote293 views1 answer
Kill mysqld_safe process mariadb
SQL
2 votes282 views1 answer
Compare date in sql
SQL
1 vote285 views1 answer
Sql headers delphi
SQL
5 votes268 views1 answer
Oracle columns in all_tables
SQL
0 vote275 views1 answer
Min mysql
SQL