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 vote146 views1 answer
Truncate a table then insert data
SQL
7 votes143 views2 answers
Sql remove duplicates based on column
SQL
0 vote122 views1 answer
Oracle last character of string
SQL
0 vote154 views1 answer
How to get parent and child record in single query using sql
SQL
-1 vote141 views1 answer
Spring boot mysql connection properties
SQL
2 votes131 views1 answer
Update trigger
SQL
13 votes200 views4 answers
Mysql remove foreign key constraint
SQL
0 vote127 views1 answer
Create table Statement Syntax in SQL Server
SQL
0 vote130 views1 answer
Postgres - Login and connect as default user
SQL
0 vote125 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL