/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 vote265 views1 answer
Match end of string regex sql
SQL
1 vote281 views1 answer
Check current sequence value postgres
SQL
0 vote276 views1 answer
Apex for oracle 11g
SQL
4 votes261 views1 answer
Force drop all tables postgres
SQL
1 vote267 views1 answer
Woocommerce mysql price table
SQL
1 vote272 views1 answer
Mysql show database size in mb
SQL
1 vote255 views2 answers
Sql select only first occurrence
SQL
1 vote259 views2 answers
Select only columns that are not empty oracle sql
SQL
4 votes297 views1 answer
Sql select limit range
SQL
6 votes329 views3 answers
What is where in sql
SQL