URGENT : A doubt regarding foreign key and Primary key

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 - 06:56:27 CST