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

7 votes290 views1 answer
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.
SQL
1 vote292 views1 answer
Launch sql script from docker in mysql
SQL
1 vote290 views2 answers
Mysql remove first and last character from string
SQL
14 votes298 views3 answers
Delete all records from table except sql
SQL
0 vote290 views2 answers
How to know the character set of an oracle databes
SQL
0 vote284 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
1 vote301 views1 answer
Spark sql concatenate string and int
SQL
3 votes273 views1 answer
Search for column name in psql
SQL
1 vote269 views2 answers
How to drop a unique constraint in sql
SQL
0 vote242 views1 answer
Hangfire clean script
SQL