/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

12 votes326 views1 answer
Docker run mysql image
SQL
0 vote342 views2 answers
Timing sql queries
SQL
2 votes325 views1 answer
Oracle index size calculation
SQL
7 votes348 views4 answers
Lowest salary in sql
SQL
0 vote315 views1 answer
Mssql describe stored procedure sqlcmd
SQL
25 votes388 views1 answer
How to update an attribute in MySQL
SQL
1 vote353 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote355 views1 answer
Select count concat string sql server
SQL
0 vote279 views1 answer
Postgresql add leading zeros
SQL
0 vote376 views1 answer
Psql check if sql script is valid
SQL