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

1 vote165 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote140 views1 answer
MySQL error code 2068
SQL
1 vote137 views1 answer
Mysql check table exists
SQL
0 vote169 views1 answer
Alter domain sql
SQL
3 votes144 views2 answers
Sql get month name
SQL
1 vote145 views1 answer
Oracle apex run 404
SQL
0 vote136 views1 answer
Postgresql create table default value timestamp
SQL
47 votes216 views6 answers
Add column mysql
SQL
0 vote143 views1 answer
Get record which is available in one table but not in another mysql
SQL
3 votes143 views1 answer
Get current month last date in sql server
SQL