Remove all tables from database SQL

Use the following script, if you want to remove all tables from database:

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"