/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

2 votes250 views4 answers
Mysql select into new table
SQL
9 votes283 views3 answers
Sql delete where in
SQL
7 votes270 views3 answers
Sql server reset auto increment
SQL
3 votes258 views2 answers
Monthname sql
SQL
2 votes267 views1 answer
Query to check cpu utilization in oracle database
SQL
0 vote253 views1 answer
Regex mongoose
SQL
0 vote241 views1 answer
Django how to get query result count
SQL
0 vote275 views1 answer
Mysql Selected All Duplicate Rows
SQL
0 vote246 views1 answer
Como hacer una consulta en sql
SQL
2 votes252 views1 answer
Set boolean flasksql
SQL