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 vote225 views1 answer
How to run sql script
SQL
2 votes322 views1 answer
Create mysql user on all hosts
SQL
0 vote303 views3 answers
Java hide mysql login credentials
SQL
11 votes302 views1 answer
Oracle view source
SQL
0 vote245 views1 answer
Delete all rows from table sqlite
SQL
5 votes324 views2 answers
Add days in oracle sql
SQL
0 vote287 views1 answer
How to combine rows in sql server procedure
SQL
2 votes310 views5 answers
Install postgresql 10 centos 7
SQL
5 votes257 views2 answers
Create table
SQL
0 vote331 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL