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 vote350 views1 answer
Sql database connectivity
SQL
0 vote404 views1 answer
Insert query return id mysql
SQL
2 votes430 views1 answer
Install postgresql centos 5
SQL
0 vote373 views1 answer
Import sql in postgresql
SQL
5 votes367 views1 answer
Sort order on two columns sql
SQL
0 vote404 views1 answer
Pl sql disable trigger
SQL
24 votes352 views2 answers
Alter table delete column
SQL
10 votes380 views2 answers
Select nextval from sequence oracle
SQL
0 vote333 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote358 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL