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

1 vote250 views1 answer
Substr sql last character
SQL
1 vote297 views1 answer
Mysql view curren querys
SQL
0 vote266 views1 answer
T-SQL - Where Used List (Table/View)
SQL
1 vote273 views1 answer
Oracle apex version view
SQL
0 vote251 views2 answers
Show slave status mysql
SQL
0 vote271 views1 answer
Postgresql cast as year and month from timestamp
SQL
1 vote272 views1 answer
Sqlalchemy order_by
SQL
1 vote268 views1 answer
Show structure of table in sql
SQL
1 vote268 views1 answer
Mysql is odd
SQL
0 vote275 views1 answer
How to query without duplicate rows in sql
SQL