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

8 votes152 views1 answer
Script to add datafile to tablespace
SQL
3 votes191 views1 answer
Oracle function
SQL
0 vote149 views1 answer
Raiserror with nowait
SQL
0 vote134 views1 answer
Ms Sql set us timezone
SQL
14 votes138 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote138 views1 answer
Sql server cannot create database diagram
SQL
1 vote136 views1 answer
Scaffold mysql database
SQL
22 votes148 views3 answers
SQL CHEATSHEET
SQL
1 vote159 views1 answer
How to see which columns are indexxed mysql
SQL
3 votes149 views1 answer
Fk in insert mysql
SQL