如何在SQL Server中删除外键？

SELECT fk.parent_object_id AS ParentID,
       pk.object_id AS ParentTableID,
       fk.referenced_object_id AS ReferencedID,
       pk.referenced_object_id AS ReferencedTableID
FROM sys.foreign_keys fk
INNER JOIN sys.tables pk
    ON fk.parent_object_id = pk.OBJECT_ID

ALTER TABLE table_name NOCHECK CONSTRAINT constraint_name;

ALTER TABLE table_name NOCHECK CONSTRAINT constraint_name;
GO
ALTER TABLE table_name DROP CONSTRAINT constraint_name;
GO