declare @TableName nvarchar(50)
declare mycursor   cursor for
select [name] from dbo.sysobjects
where xtype='u' and [name] like 'new[_]%'
open mycursor
FETCH NEXT FROM mycursor
   into @TableName
   print @TableName
while (@@FETCH_STATUS = 0)
begin
   exec('drop table '+ @TableName)
   FETCH NEXT FROM mycursor
   into @TableName
   print @TableName
end
close mycursor
deallocate mycursor