How to create a table with foreign key constraint | Sololearn: Learn to code for FREE!

0

How to create a table with foreign key constraint

There are two tables salesman and order, salesman id used as foreign key in order table

12/13/2019 6:08:27 PM

samridhi dwivedi

1 Answer

New Answer

0

And most probably salesman id is your primary key in the table salesman. You can do the following while creating the table order- Foreign key (salesman_id) References salesman (salesman_id)