外键删除(T-SQL Drop Foreign Key)
列出某张表相关的 FK Name
select distinct name from sys.objects where object_id
in
( select fk.constraint_object_id from
sys.foreign_key_columns as fk
where
fk.referenced_object_id =
(select object_id from sys.tables where name = ‘TableName‘)
)
列出主外键关系
select t.name as TableWithForeignKey, fk.constraint_column_id as FK_PartNo ,
c.name as ForeignKeyColumn
from sys.foreign_key_columns as fk
inner join sys.tables as t on fk.parent_object_id = t.object_id
inner
join sys.columns as c on fk.parent_object_id = c.object_id and
fk.parent_column_id = c.column_id
where fk.referenced_object_id = (select
object_id from sys.tables where name = ‘User‘)
order by
TableWithForeignKey, FK_PartNo;
删除外键
alter table Membership drop FK_Membership_Organization
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
