drop a foreign key constraint sql server code example

Example 1: drop foreign key

ALTER TABLE table_name
DROP CONSTRAINT fk_name;

Example 2: SQL Server Drop Foreign key

ALTER TABLE Orders

DROP CONSTRAINT FK_PersonOrder;