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

24 votes371 views6 answers
Sql change table name
SQL
0 vote326 views1 answer
Execut sql python
SQL
0 vote325 views2 answers
How to create a table from another table in sql derby
SQL
0 vote768 views2 answers
Zsh: command not found: mysq
SQL
1 vote309 views1 answer
T-SQL Alter the column data type
SQL
1 vote376 views1 answer
Opensuse restart MySQL
SQL
0 vote306 views1 answer
MySQL error code 2068
SQL
0 vote302 views1 answer
Mysql events not work
SQL
4 votes313 views1 answer
Oracle show errors compilation
SQL
0 vote363 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL