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 vote205 views1 answer
Display all node label neo4j
SQL
0 vote170 views1 answer
Search from comma separated values in sql server
SQL
16 votes223 views6 answers
Python sqlite
SQL
18 votes163 views6 answers
Creating table in MySQL
SQL
0 vote247 views1 answer
Show mysql account privilleges
SQL
56 votes568 views5 answers
Psql create user
SQL
1 vote162 views2 answers
String to date postgres
SQL
0 vote175 views1 answer
Create a sql server database programmatically
SQL
0 vote193 views1 answer
Transaction and commit trong sql server
SQL
0 vote167 views1 answer
What is metadata in sql
SQL