Answers for "make foreign key from two table in single 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 "make foreign key from two table in single columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "make foreign key from two table in single columns"

Code answers related to "make foreign key from two table in single columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "make foreign key from two table in single columns"

Code answers related to "make foreign key from two table in single columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us