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 vote342 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote355 views1 answer
Get rows from 1 table with other table empty mysql
SQL
12 votes319 views4 answers
SQL Where
SQL
3 votes426 views2 answers
Wp do sql query from function
SQL
1 vote368 views1 answer
ORA-01950
SQL
7 votes339 views1 answer
Postgres base size
SQL
17 votes350 views3 answers
Postgresql version command
SQL
0 vote361 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote399 views1 answer
Oracle pl/sql check if file exists
SQL
1 vote350 views1 answer
Select if then postgresql
SQL