/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 vote98 views1 answer
Mysql use password error
SQL
0 vote136 views1 answer
Oracle step procedure
SQL
6 votes107 views3 answers
How to delete table sqlite
SQL
1 vote68 views1 answer
Unique vs distinct sql
SQL
0 vote113 views1 answer
Ansi sql count duplicate rows
SQL
0 vote127 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote106 views1 answer
Add constraint sql
SQL
29 votes103 views6 answers
Delete all rows from table mysql
SQL
0 vote110 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote120 views1 answer
How to connect to xampp sql server on windows cmd
SQL