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

11 votes114 views3 answers
How to get last row of table in sql
SQL
3 votes110 views2 answers
Current year sql
SQL
0 vote127 views1 answer
000webhost database values insert
SQL
0 vote134 views1 answer
Mssql describe stored procedure sqlcmd
SQL
1 vote121 views1 answer
What is a Database?
SQL
0 vote128 views3 answers
Sql query checker
SQL
0 vote110 views1 answer
Sql select maximum column with other columns returned
SQL
3 votes126 views2 answers
Install mysql powershell
SQL
0 vote124 views1 answer
How to print some string in mysql
SQL
0 vote128 views1 answer
Create tables from xsd to sql server database c#
SQL