Answers for "sql server alter table add foreign key"

SQL
0

alter table add key sql server

ALTER TABLE Persons
ADD CONSTRAINT PK_Person PRIMARY KEY (ID,LastName);
Posted by: Guest on January-26-2021
0

how to set foreign key in sql server

CREATE TABLE Orders (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    PersonID int,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);
Posted by: Guest on November-03-2020

Code answers related to "sql server alter table add foreign key"

Code answers related to "SQL"

Browse Popular Code Answers by Language