/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 vote225 views1 answer
Oracle list subpartitions
SQL
0 vote193 views1 answer
Big query add table rows to another table
SQL
4 votes217 views1 answer
Check database name postgresql
SQL
-2 votes226 views1 answer
Mysql see users and passwords
SQL
0 vote234 views2 answers
Suse stop MySQL
SQL
1 vote263 views5 answers
Postgresql difference between two dates in days
SQL
1 vote244 views1 answer
Update foreign key value in mysql
SQL
0 vote219 views1 answer
Oracle list index on table
SQL
18 votes230 views6 answers
Create table mysql
SQL
0 vote376 views1 answer
Get first match in each group mysql query
SQL