SQL SERVER 删除以XX开头的表。

 

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

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