Reply To: How to delete all tables in SQL Server database?

Yes you can delete it from the command prompt try this

EXEC xp_cmdshell 'SQLCMD -U <user> -P <password> -Q 'EXEC sp_MSforeachtable @command1 = "DROP TABLE ?" ' ,no_output