Answers for "To create a FOREIGN KEY constraint on the "PersonID" column (primary key in “Persons” table) when the "Orders" table is already created, use the following SQL"

add constraint fk

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

Posted by: Guest on September-02-2020

Code answers related to "To create a FOREIGN KEY constraint on the "PersonID" column (primary key in “Persons” table) when the "Orders" table is already created, use the following SQL"