Answers for "sql add a pk as an fk to existing table"

add constraint fk

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

Posted by: Guest on September-02-2020

alter table add key sql server

ALTER TABLE Persons
ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);

Posted by: Guest on January-26-2021

Code answers related to "sql add a pk as an fk to existing table"