Use the following query to get the of for each in your :

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;



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here