Re: Help - Integrity Constraint
From: N Prabhakar <N_Prabhakar_at_Socgen-Crosby.com>
Date: 1996/11/26
Message-ID: <57fvp7$9l3_at_newton.pacific.net.sg>#1/1
)
Date: 1996/11/26
Message-ID: <57fvp7$9l3_at_newton.pacific.net.sg>#1/1
tnade_at_msn.com (Toni Nadeau) writes: > I'm Sure this is an easy one for everybody - BUT -
> How can I add foreign keys to tables that have already been created?
> I'm using PO7,SQLPlus.
> Any hellp would be appreciated - Thanks
>
> tnade_at_msn.com
Hi there,
Try the following
alter table <tablename> add (
constraint <constraint_name>
foreign key (column1, col2)
references table2 (col1,col2)
)
Regards
N.Prabhakar Received on Tue Nov 26 1996 - 00:00:00 CET