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 vote232 views2 answers
Find lowest number in sql
SQL
1 vote191 views3 answers
How to reset id column in sql server
SQL
0 vote193 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
2 votes182 views1 answer
Sqlite indexes
SQL
0 vote185 views1 answer
Hoq to import database source
SQL
1 vote180 views2 answers
Datetrunc hour snowflake
SQL
1 vote187 views1 answer
Calculate age in sql postgresql
SQL
6 votes241 views3 answers
Mysql change auto_increment start value
SQL
0 vote177 views1 answer
Get first name and last name from full name string in SQL
SQL
0 vote193 views4 answers
Mysql replace regex
SQL