by foreign key drop table 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;
ALTER TABLE table_name
DROP CONSTRAINT fk_name;
ALTER TABLE Orders
DROP CONSTRAINT FK_PersonOrder;