/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 vote359 views1 answer
Rollback to name in sql
SQL
5 votes371 views3 answers
Mysql update field from one table to another
SQL
26 votes338 views6 answers
Modify column name in sql
SQL
0 vote323 views1 answer
Store query result in variable sql
SQL
1 vote346 views2 answers
How to enable error squiggles in vs code
SQL
0 vote320 views1 answer
Mysql date + 1 day
SQL
0 vote368 views1 answer
The package java.sql is not accessible
SQL
0 vote325 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote351 views2 answers
Sql server select first day of previous year
SQL
0 vote351 views1 answer
Mysql Like(searching in the string)
SQL