DROP all tables from a Database

 EXEC sp_MSforeachtable @cmd = "DROP TABLE ?"

This hidden stored procedure will drop all tables from existing database.