How to create a table with foreign key constraint

Question

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

Answer 1

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)