Hi how Can I Add A Foreign key that references a table that has composit prima

Hi how Can I Add A Foreign key that references a table that
has composit primary key ?
example i had costumer table that has C_Id and SSN Both as
PK and another table has C_Id that must refernece C_Id in
Customers i done the usual way and got oracle error message
about uniqeness any ideas plz

Question Posted / ayd mahdy

2 Answers
3485 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i ..

Answer / manish yadav

Problem:I think you are challenging the concept of foriegn
key here, a forign key should be unique or primary key in
the refrenced table,C_ID in your case is part of composite
key i.e. its not primary key itself and nither unique key.

Solution:In customer table you may not want to change
primary key but if possible add unique constraint on C_ID
column. It should work

Is This Answer Correct ?

4 Yes

0 No

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i ..

Answer / mrs.priya

try to separate the composite key using str function when
referencing in another function to get only C_ID

Is This Answer Correct ?

0 Yes

0 No

Post New Answer