SQL SERVER如何删除以xx开头的表

SQL SERVER如何删除以xx开头的表?运行下面的存储过程可以实现

declare cur cursor 
read_only 
for select distinct table_name from information_schema.columns where table_name like 'xx_%' 

declare @name varchar(40),@sql varchar(1000) 
open cur 

fetch next from cur into @name 
while (@@fetch_status =0) 
begin 
set @sql ='drop table ' + @name 
exec (@sql) 

fetch next from cur into @name 
end 

close cur 
deallocate cur 
go 

发表评论

后才能评论