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

4 votes242 views1 answer
Oracle change nls_date_format permanently
SQL
0 vote181 views1 answer
Acual month sql
SQL
5 votes176 views1 answer
Postgres integer to serial
SQL
2 votes176 views1 answer
Get first 3 letters name in sql
SQL
1 vote247 views1 answer
How to get alternate records from a table in sql
SQL
-1 vote280 views5 answers
Left join
SQL
0 vote180 views1 answer
Hive batch drop table
SQL
1 vote195 views1 answer
How to use db.execute
SQL
0 vote187 views1 answer
Wordpress sql change site url
SQL
14 votes187 views5 answers
Sql oracle limit
SQL