Re: Help - Integrity Constraint

tnade_at_msn.com (Toni Nadeau) wrote:

>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

Use:

ALTER TABLE schema.tablename ADD ( table_constraint);

e.g.

ALTER TABLE schema1.tab1 ADD ( CONSTRAINT tab1_fk FOREIGN KEY (acol) REFERENCES schema2.tab2 (acol) );

--
Richard Ledwon
rled_at_izb-soft.de