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


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

Original text of this message