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

 

posted @ 2014-07-01 14:51  b̶i̶n̶g̶.̶  阅读(481)  评论(0编辑  收藏  举报