Get the Total Number of Rows for Each Table in Your Database

Use the following query to get the total number of rows for each table in your database:

CREATE TABLE #TempTable  (  [Table Name] [varchar](max),    [Total Records] int  );    EXEC sp_MSForEachTable @command1 = ' Insert Into #Tab(Table_Name, Total_Records) SELECT ''?'', COUNT(*) FROM ?'    SELECT * FROM #TempTable t ORDER BY t.[Total Records] DESC;    DROP TABLE #TempTable;
Share the Post:
Share on facebook
Share on twitter
Share on linkedin


Recent Articles: