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;