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 vote128 views1 answer
Db format in quotation
SQL
0 vote131 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
0 vote117 views1 answer
Mysql config address
SQL
0 vote86 views2 answers
Jupyter notebook connect to database
SQL
2 votes127 views1 answer
Oracle list duplicates
SQL
0 vote121 views1 answer
Sql DATE = GETDATE()
SQL
3 votes121 views4 answers
Psql list tables in schema
SQL
1 vote122 views1 answer
Mysql how to reset primary key
SQL
4 votes123 views1 answer
Force drop all tables postgres
SQL
0 vote132 views1 answer
Sqlite get date only
SQL