Code Snippet SQL – Get total number of records count for all the tables
Introduction
SQL Code snippet how to return total number of records count for each table in a database
Get all tables and count of records in each table
CREATE TABLE #counts
(
table_name varchar(255),
row_count int
)
EXEC sp_MSForEachTable @command1='INSERT #counts (table_name, row_count) SELECT ''?'', COUNT(*) FROM ?'
SELECT table_name, row_count FROM #counts ORDER BY table_name, row_count DESC
February 21, 2014
В·
Adi В·
No Comments
Posted in: Code Snippet, SQL
Leave a Reply