Re: How are foreign keys stored in 7.1?

In article <DBIBEI.8rD_at_crash.cts.com>, Steve Ehlke <sehlke_at_cts.com> wrote:
>I need to find out how foreign keys are stored in a table. Does
>Oracle make a copy of the other tables primary key, or does it use a
>pointer of some sort like ROWID? Eample: If Table A's primary key is
>50 bytes and table B uses this as a foreign key, is 50 bytes used for
>storing the foreign key?
>
>Steve...
>

Steve,

I'm don't KNOW this for a fact but I think the actual data is stored. Think about referencing a column that is a FK to another table. If the data is not stored in the table you're referring to then Oracle has to go to the other table to see just what's stored there since ROWID actually stores the physical address.

I could be wrong...but I don't think so.

Rod Received on Thu Jul 13 1995 - 00:00:00 CEST