declare cur cursor read_only for select distinct table_name from information_schema.columns where table_name like 'tmp_%'declare @name varchar(40),@sql varchar(1000) open curfetch next from cur into @name while (@@fetch_status =0) begin set @sql ='drop table ' + @name exec (@sql) fetch next from cur into @name endclose cur deallocate cur go
read_only
for select distinct table_name from information_schema.columns where table_name like 'tmp_%'declare @name varchar(40),@sql varchar(1000)
open curfetch next from cur into @name
while (@@fetch_status =0)
begin
set @sql ='drop table ' + @name
exec (@sql) fetch next from cur into @name
endclose cur
deallocate cur
go