/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 vote188 views1 answer
Oracle sql date winter time
SQL
8 votes185 views3 answers
Mysql alter table add index
SQL
0 vote188 views1 answer
Sql change default collation to utf8
SQL
1 vote150 views1 answer
Ms sql how to see active job current run time
SQL
0 vote191 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote269 views1 answer
Current month transactions in mysql
SQL
10 votes208 views2 answers
Oracle alter sequence nextval
SQL
0 vote218 views1 answer
How to get number of months between 2 dates sql server
SQL
1 vote183 views1 answer
Select statement to print longest name
SQL
1 vote197 views1 answer
Duplicating a MySQL table with all the data Command
SQL