删除数据库中的所有外键约束.sql

来自「sqlserver 数据库编程的绝好脚本」· SQL 代码 · 共 17 行

--删除数据库中的所有外键约束

declare @s varchar(8000)
declare tb cursor local for
select s='alter table ['+object_name(parent_obj)+'] drop constraint ['+name+']' 
from sysobjects where xtype='F'

open tb 
fetch next from tb into @s
while @@fetch_status=0
begin
	exec(@s)
	fetch next from tb into @s
end
close tb
deallocate tb