Prajeesh's Tech blog

Here is an easy way to drop all tables in a database using a single query.

exec sp_msforeachtable 'Drop table ?'

As it is an undocumented stored procedure it may be get removed any time without any notification.