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
Joomla execute raw sql
SQL
0 vote197 views1 answer
Set a default value for a column in sqlite
SQL
-1 vote218 views1 answer
Pl sql drop trigger
SQL
3 votes220 views1 answer
APEX elapsed time
SQL
7 votes202 views1 answer
Postgres base size
SQL
-1 vote214 views1 answer
Default username and password for oracle 11g
SQL
1 vote219 views1 answer
Rows to comma separated values in mssql
SQL
1 vote221 views1 answer
Sql order by where condition
SQL
0 vote200 views2 answers
2nd max salary query in sql
SQL
1 vote206 views1 answer
Oracle datafile max size 32gb
SQL