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 vote315 views1 answer
Mysql default uuid
SQL
0 vote332 views1 answer
Sql tabelle erstellen
SQL
0 vote323 views3 answers
Group_concat sql server
SQL
17 votes331 views6 answers
Current date in sql
SQL
7 votes313 views1 answer
Append column sql
SQL
16 votes335 views2 answers
Sql exists
SQL
1 vote476 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
0 vote315 views1 answer
Mysql server not running
SQL
5 votes325 views2 answers
Oracle rename table
SQL
1 vote376 views1 answer
UseSqlServer no definition
SQL