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 vote269 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote196 views1 answer
Do postgresql
SQL
0 vote198 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
1 vote194 views1 answer
Local sql server
SQL
0 vote193 views1 answer
Min and max salary and name in sql
SQL
25 votes241 views4 answers
Import mysql dump command line
SQL
3 votes222 views3 answers
Start postgresql ubuntu
SQL
0 vote230 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote200 views1 answer
Oracle last character of string
SQL
1 vote284 views3 answers
Date_add mysql
SQL