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 vote140 views1 answer
Big table in mysql
SQL
1 vote139 views1 answer
Check message id sql server
SQL
3 votes136 views2 answers
Oracle sql drop sequence
SQL
0 vote131 views1 answer
Change data type in mysql
SQL
0 vote152 views1 answer
SQL Server date literal
SQL
0 vote129 views1 answer
How to check if there is no database schema
SQL
7 votes135 views1 answer
Sql management studio display line numbers
SQL
2 votes138 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL
8 votes184 views6 answers
Insert command in sql
SQL
8 votes138 views3 answers
Connect python to mysql
SQL