mysql set column as foreign key code example

Example 1: drop foreign key

ALTER TABLE table_name
DROP CONSTRAINT fk_name;

Example 2: add constraint fk

ALTER TABLE Orders
ADD CONSTRAINT FK_PersonOrder
FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);