Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> foreign key related
Hi all
I am stuck up in a very small problem
if i have got a combined primary key of 3 fields(f1 f2 f3) in one table
(lets say tab1)
and in another table (lets say tab2(field1,field2) ) i want one of the
fields (from tab1) as the foreign key here in tab2 (lets say field1
references tab1(f1) )...
is it possible because f1 is not the primary key its a part of the primary key of table tab1
hope i m clear with the problem
Regards and Thanks in advance
Parvinder
Received on Mon Nov 29 1999 - 07:58:30 CST