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 vote324 views1 answer
Oracle locked objects
SQL
0 vote311 views1 answer
Sql count total by foreign key
SQL
0 vote323 views1 answer
Sort by
SQL
0 vote327 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
2 votes361 views1 answer
Sql compare strings
SQL
1 vote290 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote306 views2 answers
Sql searching via key word
SQL
2 votes317 views1 answer
Column names in oracle sql
SQL
18 votes306 views6 answers
Create table mysql
SQL
25 votes306 views4 answers
Metadata
SQL