Re: URGENT : A doubt regarding foreign key and Primary key

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 30 Nov 1999 20:00:19 +0100
Message-ID: <943988503.3497.0.pluto.d4ee154e@news.demon.nl>

Unless you cluster those two tables, they will NOT share the same storage.

Hth,

--
Sybrand Bakker, Oracle DBA
Parvinder Singh <parora_at_questone.com> wrote in message news:3843C9D2.79A55ACC_at_questone.com...
> Hi all
>
> I have got a small doubt ...if i have got a field in a table which is a
> primary key and that field is a foreign key in some other table then
> these will the storage of these two fields be the same ?
>
> for e.g
>
> Tab1
>
> - ID (P)
> - Number
>
> Tab2
> -Identity(F)
> -Description
>
> now the Identity of tab2 is a foreign key and is referencing the ID of
> Tab1 and over there its a primary key (obviously)
>
> so the storage of Identity and ID will be the same or will it be
> different ??? in the sense will a value of ID - 40 and Identity - 40
> ...will these two values be replicated in different storeage areas or
> only in one common place ?..Any idea about it ?
>
> I hope i am clear with my doubt
>
> Thanks in advance
>
> Regards
> Parvinder
>
> Please reply to parora_at_questone.com too !
>
Received on Tue Nov 30 1999 - 13:00:19 CST