DROP all tables from a Database

Suthish Nair

 EXEC sp_MSforeachtable @cmd = "DROP TABLE ?"

This hidden stored procedure will drop all tables from existing database.

Comments

Join the conversation! Your thoughts help the community grow.