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

2 votes158 views1 answer
Sql finding longest and shortest names in a fleld
SQL
2 votes138 views1 answer
Oracle sql drop table purge
SQL
0 vote165 views1 answer
How to install Firebird
SQL
0 vote147 views1 answer
How to convert DateTime to VarChar SQL
SQL
3 votes99 views1 answer
How to get list of synonyms in oracle
SQL
1 vote138 views1 answer
Sql server reseed single table
SQL
0 vote187 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
5 votes171 views2 answers
Oracle list columns
SQL
10 votes157 views4 answers
SELECT FROM WHERE
SQL
1 vote156 views1 answer
Date in where on datetime column clause mysql
SQL