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 vote200 views1 answer
Trigger stock phpmyadmin
SQL
0 vote169 views1 answer
Fetch second word from a string in ms sql
SQL
1 vote215 views1 answer
Nullif postgresql
SQL
0 vote168 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote201 views1 answer
No query unable to fetch row sqlite
SQL
0 vote188 views1 answer
Postgres copy command
SQL
5 votes209 views2 answers
Add days in oracle sql
SQL
0 vote174 views1 answer
Sql create table with datetime automatically
SQL
0 vote199 views1 answer
How to create notes in mysql
SQL
1 vote182 views1 answer
Insert column after column mysql
SQL