Tuesday, April 19, 2011

Delete all table in a Database

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"

Deletes all tables and this operation can also be rolled back!!

No comments:

Post a Comment