SQL Server 删除外键

 

 

SELECT 'alter table ['+ OBJECT_NAME(FKEYID) + '] drop constraint ' + OBJECT_NAME(CONSTID)  FROM  SYSREFERENCES


--1，取出表的所有外键
SELECT 'alter table ['+ OBJECT_NAME(FKEYID) + '] drop constraint ' + OBJECT_NAME(CONSTID)  FROM  SYSREFERENCES where OBJECT_NAME(FKEYID)='Gy_InOutSub'
--取得SQL
alter table [Gy_InOutSub] drop constraint FK_Gy_InOutSub_Gy_InOutMain

--2.从另一个表中取SQL： Gy_InOutMain的主键被 Gy_InOutSub作了外键。不能用Truncate table　Gy_inOutMain
SELECT 'alter table ['+ OBJECT_NAME(FKEYID) + '] drop constraint ' + OBJECT_NAME(CONSTID)  FROM  SYSREFERENCES where OBJECT_NAME(rkeyid)='Gy_InOutMain'
--取得SQL
alter table [Gy_InOutSub] drop constraint FK_Gy_InOutSub_Gy_InOutMain