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

4 votes396 views3 answers
Postgres drop all tables
SQL
1 vote337 views1 answer
Postgres concat_ws
SQL
1 vote353 views3 answers
Execute sp in sql server
SQL
0 vote355 views1 answer
Postgres select from values
SQL
0 vote331 views1 answer
Mysql local password denied
SQL
0 vote313 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote324 views1 answer
Not between mysql
SQL
0 vote340 views1 answer
How to get initials in sql
SQL
0 vote354 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote330 views1 answer
Sqlserver now
SQL