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;

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.