/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 vote154 views1 answer
Play framework connection via windows sql server
SQL
3 votes229 views4 answers
Sql interview questions
SQL
0 vote143 views1 answer
Show all mongodb
SQL
0 vote131 views1 answer
Sql constarint
SQL
0 vote107 views2 answers
Avg() sql
SQL
11 votes139 views6 answers
Mysql else if
SQL
17 votes140 views3 answers
Cast in sql server
SQL
0 vote134 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
7 votes143 views1 answer
Query postgres delete duplicates
SQL
0 vote134 views1 answer
Exclude last comma separated string mysql
SQL