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
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