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 vote181 views1 answer
Mysql in clausule string array
SQL
0 vote176 views1 answer
Mysql beautifier terminla
SQL
0 vote198 views2 answers
How to drop mili second in sql
SQL
0 vote171 views1 answer
Frename oracle
SQL
0 vote176 views1 answer
Postgres statistics
SQL
-2 votes179 views1 answer
Group functions in sql
SQL
8 votes168 views2 answers
Python simple connect to mysql
SQL
6 votes176 views1 answer
Oracle trigger after logon on database
SQL
0 vote177 views1 answer
Database traccar
SQL
1 vote161 views1 answer
DATE_SUB postgres
SQL