/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

2 votes286 views2 answers
Calculate percentage in sql
SQL
8 votes261 views1 answer
Database backup in mysql server recovery
SQL
1 vote275 views1 answer
Base64 encode sql server
SQL
0 vote276 views1 answer
Postgresql show owner of database
SQL
3 votes262 views1 answer
Force using index plsql
SQL
0 vote270 views1 answer
Pgsql is not permitted to log in
SQL
0 vote282 views1 answer
Group by 15 minute interval sql server
SQL
-1 vote266 views1 answer
How to create foreign key in sql server management studio
SQL
15 votes281 views5 answers
Show tables in oracle
SQL
0 vote281 views1 answer
Mariadb create index if not exists
SQL