sqlserver 2014 删除主键约束

select * from dict where DictCode != ‘‘ and PId=5

truncate table menu

SELECT * FROM sys.foreign_keys
WHERE referenced_object_id=OBJECT_ID(‘menu‘); --找到引用该表的外键

--ALTER TABLE dbo.XX DROP constraint FK_User_XX

ALTER TABLE dbo.RoleMenu DROP constraint FK_Menu_RoleMenu --删除外键

select * 
from sys.foreign_keys 
where referenced_object_id=object_id(‘menu‘)
order by 1  --查询引用的外键

 alter table menu drop constraint FK_dbo.RoleMenu_dbo.Menu_MenuId


 select
? ? fk.name,fk.object_id,OBJECT_NAME(fk.parent_object_id) as referenceTableName
from sys.foreign_keys as fk
join sys.objects as o on fk.referenced_object_id=o.object_id
where o.name=‘menu‘

?-- ? ?得到 ?外键消息?FK__photo__x_id__6991A7CB -- 得到 FK_dbo.RoleMenu_dbo.Menu_MenuId

 ?ALTER TABLE dbo.RoleMenu? DROP CONSTRAINT Menu_MenuId

 select fk.name,object_name(fk.parent_object_id) as referencetablename
from sys.foreign_keys as fk
join sys.objects as o on fk.referenced_object_id=o.object_id
where o.name = ‘Menu‘


alter table RoleMenu
drop constraint  FK_RoleMenu_Menu_MenuId
ALTER TABLE 表名 
DROP CONSTRAINT 约束名


ALTER TABLE Menu 
DROP CONSTRAINT FK_dbo.RoleMenu_dbo.Menu_MenuId

以上代码测试均失败,

最后,直接删除表主键

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!