Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Premium
Register
Login
DROP all tables from a Database
Suthish Nair
Jan 30, 2012
2.2
k
0
0
Blogs
WhatsApp
DROP all tables from a Database
EXEC sp_MSforeachtable @cmd = "DROP TABLE ?"
This hidden stored procedure will drop all tables from existing database.
DROP all tables from a Database
Next Recommended Reading
Insert Values from One Database Table to Another Database Table in SQL Server