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

6 votes193 views1 answer
Phpmyadmin password root
SQL
0 vote202 views1 answer
How to select a row in sql
SQL
0 vote192 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote193 views1 answer
Is not null postgresql
SQL
0 vote194 views1 answer
Can we rollback in sql
SQL
0 vote166 views1 answer
Online sql compiler
SQL
1 vote203 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote147 views1 answer
Oracle sql developer script output limit
SQL
0 vote246 views1 answer
Postgresql remove new line from string
SQL
-1 vote156 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL