SET NOCOUNT ON;

DECLARE @table nVARCHAR(255)

DECLARE db_cursor CURSOR FOR
select t.name
from sys.tables t inner join
sys.schemas s on
t.schema_id=s.schema_id
order by 1

OPEN db_cursor

FETCH NEXT FROM db_cursor INTO @table

WHILE @@FETCH_STATUS = 0
BEGIN
declare @sql nvarchar(1000)

set @sql = 'drop table [' + @table + ']'

exec sp_sqlexec @sql

FETCH NEXT FROM db_cursor INTO @table
END

CLOSE db_cursor
DEALLOCATE db_cursor