/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 vote169 views1 answer
Sql select table header
SQL
10 votes291 views4 answers
Mysql if else
SQL
0 vote165 views1 answer
Oracle list datafiles
SQL
0 vote154 views1 answer
Difference between min and max date sql
SQL
92 votes1.8K views6 answers
Substring
SQL
14 votes146 views2 answers
How to auto increment in sql
SQL
28 votes151 views4 answers
Delete database mysql
SQL
0 vote142 views1 answer
Sql injection mitigation
SQL
0 vote160 views1 answer
Sp in sql server
SQL
0 vote181 views1 answer
For row in sql database python loop
SQL