drop

declare @n int
declare @name varchar(255)
declare @sql varchar(255)
begin
create table #tablename(name varchar(255))
insert into #tablename
select name from tempdb..sysobjects
where name like '%User%' or name like '%R%' or name like '%avg%' or name like '%max%' or name like '#'
select @n = (select count(*) from #tablename)
while (@n > 0)
begin
 select @name=min(name) from #tablename  

 select @sql='drop table '+ @name
 exec(@sql)
 delete from #tablename where name=@name
 select @n=@n+1
end

drop table #tablename
end 




--select name from tempdb..sysobjects where type ='U'