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 votes267 views1 answer
Force drop all tables postgres
SQL
7 votes267 views2 answers
Add column table pl sql
SQL
0 vote263 views1 answer
Limiting query result using where in sql
SQL
0 vote286 views2 answers
How to add CHECK constraint to a column in postgres
SQL
1 vote268 views1 answer
Sql server update column based on another table
SQL
0 vote298 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote279 views2 answers
Uninstall postgresql mac
SQL
2 votes285 views2 answers
Storing timezones in postgres
SQL
10 votes277 views1 answer
User_dependencies
SQL
59 votes442 views6 answers
Alter table sql
SQL