批量删除表

CREATE     PROCEDURE    dropTable  @tableName   varchar ( 40 )
AS  
declare  cur  cursor  read_only 
for   select   distinct  table_name  from  information_schema.columns  where  table_name  like   @tableName

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