Re: How are foreign keys stored in 7.1?

From: Bill Meahan <wmeahan_at_sun1.fsic.ford.com>
Date: 1995/07/11
Message-ID: <3ttqfd$ls5_at_eccdb1.pms.ford.com>#1/1


sehlke_at_cts.com (Steve Ehlke) 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...
>

The whole key is stored in Table B.

-- 
Bill Meahan  wmeahan_at_sun1.fsic.ford.com
Ford Motor Company -- End User Support - North America
Not an official statement of Ford Motor Company or anyone else
except the author (though my dog tends to agree with all I say)
Received on Tue Jul 11 1995 - 00:00:00 CEST

Original text of this message