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 vote153 views1 answer
Write SQL in ruby on rails
SQL
1 vote150 views1 answer
Tsql get beginning of year
SQL
0 vote151 views1 answer
How to insert multiple rows in mysql using laravel
SQL
7 votes162 views1 answer
Sql pagination oracle
SQL
0 vote152 views1 answer
Count columns psql(PostreSQL)
SQL
1 vote147 views1 answer
T-SQL Alter the column data type
SQL
1 vote144 views1 answer
Get last week data in mysql
SQL
3 votes150 views2 answers
Truncate all tables
SQL
2 votes186 views3 answers
How to replace null values in sql
SQL
2 votes157 views1 answer
Oracle list grants on procedure
SQL