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)
);

Source: computerscienceai.com

Similar codes

0 vote285 views1 answer
Drop CHECK constraint sql
SQL
0 vote308 views1 answer
Mysql delete entire row on condition
SQL
0 vote290 views1 answer
Apex for oracle 11g
SQL
59 votes459 views6 answers
Alter table sql
SQL
11 votes274 views2 answers
Having in sql
SQL
2 votes279 views4 answers
Sql query interview questions
SQL
3 votes270 views3 answers
Your password does not satisfy the current policy requirements
SQL
1 vote294 views1 answer
Mysql check if string contains comma separated
SQL
58 votes544 views6 answers
Create new user in postgres
SQL
1 vote266 views1 answer
Mysql connect command
SQL