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 vote362 views1 answer
Amount of entries in a table psql
SQL
-2 votes352 views3 answers
How to fetch first 10 rows in sql
SQL
5 votes359 views1 answer
Sql table columns
SQL
0 vote309 views1 answer
Suse start MySQL
SQL
0 vote329 views1 answer
Update database collation in postgresql
SQL
1 vote353 views4 answers
Psql check tables command
SQL
-1 vote335 views1 answer
Capitole toulouse
SQL
0 vote334 views1 answer
Insert output identity
SQL
2 votes371 views1 answer
Alter table add column and foreign key mysql
SQL
3 votes318 views1 answer
Delete all content in table mysql
SQL