sp_MSForEachTable Example T-SQL Code to Count all Rows in all Tables in MS SQL Server Database

As you can see, I altered the sp_MSForEachTable command to an INSERT statement instead of a SELECT statement. This will insert the row count for all tables in a SQL database into the RowCount table. As a last step, we can execute the below t-sql SELECT ..

www.kodyaz.com