To drop all tables from a sql server database with one command is very simple.
You can use the system stored procedure "sp_MSforeachtable".

Paste in query editor the snippet:

exec sp_MSforeachtable "DROP TABLE ? PRINT '? dropped' "

That's all folks!