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 vote323 views1 answer
How to get one year old query from plan cache
SQL
1 vote304 views1 answer
How do you use sql in you company
SQL
6 votes307 views1 answer
Oracle list primary key
SQL
25 votes306 views6 answers
Modify column name in mysql
SQL
0 vote330 views1 answer
Add week ending date sql server
SQL
21 votes315 views1 answer
SQL cheat sheet pdf
SQL
1 vote275 views1 answer
Update from select join
SQL
-2 votes300 views1 answer
Remove root password mysql
SQL
0 vote295 views1 answer
Sql get guid
SQL
0 vote295 views1 answer
Dapper run sql script with parameters
SQL