/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 vote137 views1 answer
Create-table-with-index-organization
SQL
2 votes166 views1 answer
Merge two columns in sql oracle
SQL
2 votes147 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote144 views1 answer
Sql bild in function
SQL
1 vote134 views1 answer
Oracle difference between two dates in years
SQL
0 vote188 views1 answer
Mysql collation portugues brasil
SQL
0 vote131 views1 answer
Ignore case in string sql
SQL
0 vote133 views1 answer
How to check even or odd in sql
SQL
0 vote97 views1 answer
Import sql file in mysql linux
SQL
0 vote141 views1 answer
Drop procedure sql
SQL