SQLServer 删除所有表的外键约束

DECLARE c1 cursor for    
select alter table [+ object_name(parent_obj) + ] drop constraint [+name+];
from sysobjects
where xtype = F
open c1declare @c1 varchar(8000)
fetch next from c1 into @c1while(@@fetch_status=0)
begin
exec(@c1)
fetch next from c1 into @c1
endclose
c1deallocate c1

 

SQLServer 删除所有表的外键约束,布布扣,bubuko.com

SQLServer 删除所有表的外键约束

上一篇:mysql字段截取(转)


下一篇:Xss里img标签的一些利用