/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

17 votes397 views6 answers
Change column name in sql
SQL
0 vote367 views2 answers
How to type a blank discord messgae
SQL
0 vote351 views1 answer
Laravel eloquent get generated sql
SQL
0 vote344 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote385 views1 answer
Sql missing values
SQL
6 votes331 views1 answer
Oracle trigger after connect
SQL
1 vote346 views1 answer
Sql get all columns from one table but one from another inner join
SQL
1 vote369 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote333 views1 answer
Postgresql create table default value timestamp
SQL
5 votes307 views1 answer
Copy table from one database to another mysql
SQL