/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

1 vote279 views1 answer
How to get alternate records from a table in sql
SQL
8 votes240 views2 answers
Sqlsrv default port
SQL
0 vote204 views1 answer
Adonisjs ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote223 views3 answers
Delete in SQL SERVER
SQL
0 vote201 views1 answer
Oracle last character of string
SQL
3 votes390 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
1 vote274 views2 answers
Intersect sql
SQL
3 votes188 views2 answers
Mysql create database
SQL
1 vote215 views2 answers
Rebuild index sql server
SQL
0 vote200 views1 answer
Sql reverse order of results
SQL