/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

38 votes304 views4 answers
Count sql
SQL
0 vote299 views2 answers
Laravel: customize or extend notifications - database model
SQL
0 vote339 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
1 vote297 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
18 votes306 views3 answers
Find column name in database
SQL
2 votes323 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote280 views1 answer
Oracle last connection
SQL
0 vote292 views1 answer
Psql check if value in array
SQL
15 votes316 views4 answers
Mysql export database command line
SQL
12 votes321 views2 answers
Select into insert sql server
SQL