/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 vote206 views1 answer
Display all node label neo4j
SQL
0 vote161 views1 answer
Postgresql get current user name
SQL
41 votes254 views6 answers
Alter table add column in SQL Server
SQL
0 vote173 views1 answer
Implicit inner join table alias
SQL
2 votes163 views1 answer
How to delete view in sql
SQL
0 vote133 views1 answer
Connection error in mysql workbench
SQL
1 vote162 views1 answer
How to update date add hours in postgresql
SQL
0 vote165 views1 answer
Drop all tables db2
SQL
0 vote680 views1 answer
T sql less than date
SQL
0 vote181 views2 answers
Timing sql queries
SQL