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 vote186 views1 answer
Criteria builder select subset of column
SQL
2 votes206 views1 answer
Q operator in plsql
SQL
1 vote177 views1 answer
Sql auto timestamp
SQL
0 vote183 views2 answers
Mysql multiply
SQL
0 vote189 views1 answer
Insert thai language sql server
SQL
0 vote194 views1 answer
Mysql workbench indent formatting
SQL
1 vote248 views1 answer
Hangfire clear all jobs
SQL
1 vote215 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote204 views1 answer
Closure in sql
SQL
1 vote204 views1 answer
Age postgres
SQL