Drop all MS SQL tables... quickly.

	   When you absolutely positively got to delete every table in
	   the database.

Posted: Mon 18 May, 2015, 10:53
Handy command for quickly dropping all tables in an MS SQL database:

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
        

Courtesy of Gurpreet Singh Gill.