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

2 votes256 views1 answer
Creating a view SQL
SQL
0 vote266 views1 answer
How to add session data into mysql database from button
SQL
0 vote273 views3 answers
Sql parenthetical expression examples
SQL
0 vote275 views1 answer
Dump only data
SQL
0 vote284 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
0 vote246 views1 answer
Json_remove mysql
SQL
1 vote422 views1 answer
Postgres upgrade to superuser
SQL
0 vote237 views1 answer
How to see the query of a view in mysql
SQL
1 vote250 views1 answer
Psql client write to bash variable
SQL
0 vote257 views1 answer
Monthly Birthday SQL Query
SQL