Post
Ask Question

DROP all tables from a Database

 EXEC sp_MSforeachtable @cmd = "DROP TABLE ?"

This hidden stored procedure will drop all tables from existing database.
Next Recommended Reading Insert Values from One Database Table to Another Database Table in SQL Server