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

1 vote26 views1 answer
SQLSTATE[HY000] [2002]
SQL
4 votes29 views2 answers
How to count items with same name in sql
SQL
0 vote30 views1 answer
Postgresql update to unique
SQL
0 vote34 views2 answers
Drop check constraint in ms sql
SQL
1 vote26 views1 answer
Oracle rolling back transactions
SQL
0 vote32 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
3 votes30 views2 answers
To_char oracle
SQL
6 votes31 views2 answers
Mysql interval 1 day
SQL
0 vote32 views1 answer
Oracle current session details
SQL
1 vote35 views2 answers
List tables sqlalchemy
SQL