delete foreign key sql
snippet in sql

delete foreign key sql

user2436


ALTER TABLE Orders

DROP CONSTRAINT FK_PersonOrder; 

remove foreign key

user5956


ALTER TABLE Orders

ADD CONSTRAINT FK_PersonOrder

FOREIGN KEY (PersonID)
REFERENCES Persons(PersonID);