Re: Use 1/5 primary key from a table as FK of another table...

I am guessing here but I think you are saying if you have a primary key with 5 columns in it and you want to use of of the columns as a foreign key? I believe you can use the index as a foreign key as long as the column you are referencing is first in the index list.

Huoy-Jii Khoo wrote:
>
> Hi,
>
> Sorry for the beginner's question.
>
> I was wondering if I could use JUST one out of five primary keys that I
> have in table A as the foreign key of another table, let say table B?
>
> Is that possible in Oracle? Is that ok?
>
> Thanks.
> jii
Received on Tue Oct 24 2000 - 00:36:08 CDT