/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 vote349 views1 answer
Oracle decode
SQL
14 votes355 views5 answers
Set password for postgres user ubuntu
SQL
1 vote311 views1 answer
Postgres install unaccent extension
SQL
1 vote306 views1 answer
Oracle convert run duration to number
SQL
7 votes297 views2 answers
N highest salary in sql
SQL
0 vote316 views1 answer
Two inner joins sql
SQL
-1 vote323 views3 answers
Compute age mysql
SQL
0 vote311 views1 answer
Mysql update even / odd rows
SQL
0 vote339 views1 answer
Add week ending date sql server
SQL
0 vote305 views1 answer
This week mysql
SQL