/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 vote278 views1 answer
Postgresql regular expression special characters
SQL
0 vote284 views1 answer
Big table in mysql
SQL
6 votes290 views5 answers
Sql add months to date
SQL
0 vote297 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
1 vote274 views1 answer
Sql get missing id
SQL
4 votes310 views2 answers
Float postgres
SQL
4 votes277 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote297 views1 answer
Postgresql delete limit
SQL
0 vote304 views1 answer
Timestamp(0) postgresql
SQL
2 votes286 views1 answer
Columns Present in a table
SQL