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 vote217 views1 answer
Varchar format not case sensitive sql
SQL
0 vote198 views1 answer
Mysql date format unix timestamp
SQL
2 votes191 views1 answer
Update trigger
SQL
0 vote247 views1 answer
Oracle running queries
SQL
0 vote346 views2 answers
Create fulltext index mysql
SQL
0 vote188 views1 answer
C# mysql data reader from two tables
SQL
2 votes197 views1 answer
Mysql add boolean column
SQL
1 vote186 views2 answers
Drop function in sql
SQL
0 vote193 views1 answer
Delete insert record in sql server
SQL
3 votes218 views2 answers
How to force truncate a table in mysql
SQL