Microsoft SQL Server handy commands

Delete all the tables of a database Open a query window under the database whose tables you wanna delete Run:  EXEC sp_MSforeachtable @command1 = “DROP TABLE ?” All the tables may not the deleted because of some foreign key constraints, thats why you need to run it several times to delete all of them.