/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 vote108 views1 answer
Sql auto timestamp
SQL
0 vote127 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote130 views1 answer
Sql decimal to 2 places
SQL
4 votes117 views2 answers
Convert utc to est sql
SQL
4 votes122 views2 answers
Oracle sql group by date year
SQL
11 votes440 views4 answers
Reset identity column values in sql server
SQL
2 votes111 views1 answer
SQL column name Postgre
SQL
0 vote114 views2 answers
Which MySQL statement is used to delete data from a database
SQL
0 vote142 views1 answer
Psql create usr
SQL
0 vote112 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL