/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 vote170 views1 answer
Sql change date format
SQL
4 votes181 views1 answer
SQL find text in SP
SQL
0 vote197 views1 answer
Mysql extract day from date leading zero
SQL
0 vote195 views1 answer
Normalization in database
SQL
0 vote259 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
5 votes180 views1 answer
JBDC
SQL
1 vote208 views1 answer
Sql check roles
SQL
0 vote183 views1 answer
Sql getdate minus 1 day without time
SQL
16 votes189 views4 answers
Mysql import from sql file
SQL
0 vote191 views1 answer
Login failed for user sql server
SQL