Answers for "how to add constraint in sql"

add constraint fk

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

Posted by: Guest on September-02-2020

add constraint sql

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

Posted by: Guest on January-26-2021

Code answers related to "how to add constraint in sql"