去除外键的存储过程代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】去除外键的存储过程

作者:疯狂的流浪 / 发布于2011/1/10/ 853

<div>create proce prdropforeignkeys
@chvreferencedtable varchar(30)
as
declare @chvtablewithforeignkey varchar(30),
 @chvforeignkey varchar(30),
 @chvsql varchar(255)
declare cufks cursor for 
select tb.name,fk.name from 
((sysobject tb inner join sysreferences r on tb.id=r.fkeyid)
 inner join sysobjects fk on r.constid=fk.id)
 inner join sysobjects refd on refd_tb.id=r.rkeyid)
where <a href="mailto:refd_tb.name=@chvreferencedtable">refd_tb.name=@chvreferencedtable</a>
open cufks
fetch next from cufks into @chvtablewithforeignkey,@chvforeignkey</div>
<div>while (@@fetch_status<>-1)
begin
 select @chvsql='alter <a href="mailto:table'+@chvtablewithforeignkey">table'+@chvtablewithforeignkey</a>+
 'drop constraint <a href="mailto:'+@chvforeignkey">'+@chvforeignkey</a>
 exec(@chvsql)
fetch next from cufks into @chvtablewithforeignkey,@chvforeignkey
end
deallocate cufks</div>

试试其它关键字

　去除外键　

同语言下

可能有用的

疯狂的流浪贡献的其它代码(8)