Home Forums SQL Server 2008 SQL Server 2008 - General sp_MSforeachtable Drop Tables RE: sp_MSforeachtable Drop Tables
Susantha Bathige
Ten Centuries
Points: 1040
More actions
March 12, 2010 at 1:14 am
#1132503
Here is another method;
Create a stored proc in each DB to delete the empty tables and then exec that SP by using sp_MsForEachDB.
Susantha