/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 vote114 views1 answer
Mysql identified by syntax error
SQL
2 votes113 views2 answers
Exec procedure pl sql
SQL
2 votes118 views3 answers
Current month mysql query
SQL
1 vote119 views1 answer
Where not in array sql
SQL
13 votes134 views2 answers
Sqlite rename table
SQL
0 vote127 views1 answer
Compare if is null sql
SQL
0 vote113 views1 answer
Sql create text column limited values
SQL
0 vote112 views1 answer
Sql last 7 days
SQL
0 vote131 views3 answers
Postgres date difference seconds
SQL
0 vote110 views1 answer
Check sql database table lock
SQL