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 vote230 views1 answer
Oracle sql all days except weekends
SQL
1 vote206 views1 answer
Apex run 404
SQL
0 vote215 views1 answer
Console output pl sql
SQL
0 vote233 views1 answer
Mysql best varchar length size
SQL
1 vote221 views1 answer
Mysql best tutorial for beginners
SQL
0 vote220 views1 answer
How to write if case in select query in select statement
SQL
0 vote215 views1 answer
Sql menampilkan data tabel
SQL
0 vote212 views1 answer
PG::ForeignKeyViolation: ERROR: update or delete on table violates foreign key constraint
SQL
1 vote228 views1 answer
Sql view where tables have same column name combine results
SQL
1 vote210 views1 answer
How to truncate a table in databse
SQL