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 vote151 views1 answer
SQL Hello, [firstname] [lastname]
SQL
1 vote156 views1 answer
Oracle list constraints
SQL
0 vote151 views1 answer
Concatenate columns in table
SQL
0 vote156 views2 answers
Nosqlbooster query other collection
SQL
0 vote178 views1 answer
Create a plsql object
SQL
10 votes162 views4 answers
SELECT FROM WHERE
SQL
2 votes179 views1 answer
How to get non distinct values in sql
SQL
0 vote144 views1 answer
Mysql database is not starting in xampp
SQL
0 vote149 views1 answer
Find number of entries sql
SQL
3 votes163 views2 answers
Install mysql powershell
SQL