Foreign key with multiple columns.

I have two table say emp & dept.

In the emp table I have set 3 columns as primary key (composite key)

In the dept table again I have all the 3 columns in the emp table for which I want to establish a foreign key relation ship with the corresponding key in the emp table.

Is this possible?
BijumathewsAsked:
Who is Participating?
 
TarekEslimConnect With a Mentor Commented:
yes,

use create index
or
 use alter table add constarint.

Tarek
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.