>USE YourDataBase
>DECLARE @TableName AS varchar(8000)
>DECLARE @sql       AS varchar(8000)
>SELECT @TableName = MIN(Table_Name) FROM INFORMATION_SCHEMA.Tables
>WHILE @TableName IS NOT NULL
>      BEGIN
>          SET @sql = 'DROP TABLE '+@TableName
>          EXEC (@sql)
>          SELECT @TableName = MIN(Table_Name) FROM INFORMATION_SCHEMA.Tables WHERE Table_Name > @TableName
>      END
>