/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 vote341 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote290 views1 answer
Sql log file inof
SQL
0 vote280 views1 answer
How to select an index in oracle sql
SQL
0 vote312 views1 answer
Get initial in sql
SQL
27 votes271 views4 answers
Get all tables with column name sql
SQL
0 vote256 views1 answer
Wordpress sql change site url
SQL
0 vote285 views1 answer
Cross apply top for each row t1
SQL
0 vote315 views1 answer
Postgresql alter table sequence
SQL
5 votes263 views1 answer
Oracle sysdate
SQL
2 votes296 views2 answers
Mysql count rows returned
SQL