/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 vote294 views1 answer
Postgres set default schema
SQL
1 vote293 views1 answer
Sql into vs insert into
SQL
0 vote285 views1 answer
Unique element in sql
SQL
0 vote308 views1 answer
Running percentage of total postgres
SQL
1 vote286 views1 answer
Create table tablename as select * from tablename
SQL
0 vote285 views1 answer
Oracle sql date winter time
SQL
2 votes303 views1 answer
Sql server current date minus 5 years
SQL
1 vote310 views1 answer
Sql server today minus n
SQL
0 vote295 views1 answer
Mysql select smaller of two values
SQL
13 votes277 views2 answers
Oracle inner join
SQL