devxlogo

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

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;

devx-admin

Share the Post: