/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

2 votes244 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote270 views1 answer
Oracle pl/sql check if file exists
SQL
0 vote261 views2 answers
List all constraints in postgres
SQL
0 vote261 views3 answers
Condition in count sql
SQL
0 vote246 views1 answer
Mysql timediff
SQL
11 votes227 views2 answers
MySQL DISTINCT
SQL
-1 vote251 views1 answer
Can pandas fetch data from sql
SQL
0 vote240 views1 answer
Oracle to_number
SQL
1 vote225 views1 answer
Loading local data is disabled mysql
SQL
-1 vote265 views1 answer
How to reset autoincrement in sqlite java
SQL