Re: HELP! - How to use combined key as foreign key in another table???
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/21
Message-ID: <571k67$5mv_at_newton.pacific.net.sg>#1/1
Date: 1996/11/21
Message-ID: <571k67$5mv_at_newton.pacific.net.sg>#1/1
Hi there,
Create your detail table without any referential integrity in the CREATE statement.
Alter the child table to include the foreign key constraint
alter table child table add (
constraint child_fk
foreign (col1, col2)
references master_table(col1,col2)
)
I am not sure about the exact syntax. I think the above is correct. But please refer SQL*Language reference manual for the exact syntax.
Regards
N.Prabhakar Received on Thu Nov 21 1996 - 00:00:00 CET