How to Drop Foreign Key Constraint in SQL Server Database

To drop a foreign key from a table, use the ALTER TABLE clause with the name of the table (in our example, student) followed by the clause DROP CONSTRAINT with the name of the foreign key constraint.

ALTER TABLE little DROP CONSTRAINT fk_little_1;