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 vote242 views1 answer
Create table sql generator
SQL
0 vote216 views1 answer
Sql examples from your work
SQL
13 votes244 views1 answer
Select count of distinct values sql
SQL
0 vote251 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
5 votes228 views4 answers
Sql check
SQL
1 vote242 views1 answer
Postgresql how to show table names
SQL
2 votes239 views1 answer
Compare date in sql
SQL
-1 vote237 views3 answers
SQL to LINQ converter
SQL
0 vote248 views1 answer
Mssql disable foreign key constraint
SQL
8 votes219 views1 answer
Sql remove characters from string right
SQL