Answers for "alter table add constraint foreign key multiple columns"

foreign key multiple columns

CREATE TABLE Employee(
    EmployeeID int NOT NULL PRIMARY KEY,
    LastName varchar(50) NOT NULL,
    FirstName varchar(20) NOT NULL,
    Age int,
    DeptNo int,
    PRIMARY KEY (EmployeeID),
    CONSTRAINT FK_PersonOrder FOREIGN KEY (DeptNo)
    REFERENCES Department(DeptNo)
);

Posted by: Guest on July-06-2021

Code answers related to "alter table add constraint foreign key multiple columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table add constraint foreign key multiple columns"

Code answers related to "alter table add constraint foreign key multiple columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "alter table add constraint foreign key multiple columns"

Code answers related to "alter table add constraint foreign key multiple columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us