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'
10-10