How To Delete All Tables In A Database Using sql

To Delete All Tables In A Database At a time Using One Query.

USE [database name]
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"