/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

1 vote309 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
0 vote334 views2 answers
Athena drop partition
SQL
17 votes311 views5 answers
Order by sql
SQL
0 vote312 views1 answer
Provera dupliranih konatakata
SQL
0 vote332 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote328 views2 answers
Postgres another version
SQL
0 vote322 views1 answer
Drop all triggers oracle
SQL
0 vote363 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote312 views1 answer
Drop all procedures sql server
SQL
1 vote322 views1 answer
Sql avg group by
SQL