Adding ON DELETE CASCASE as an afterthought...

From: Don Hall <dhall_at_twoil.com>
Date: Tue, 27 Jul 1999 21:09:04 +0000
Message-ID: <E239981030E8C99B.C67870C31F262334.56D4F849A51F3E39_at_lp.airnews.net>

Is it possible to modify a column constraint, currently defined as a foreign key, to add the "ON DELETE CASCADE" option?   When using the following command: 

ALTER TABLE INTRHIST_TICK
MODIFY  SEQ_INTRHIST NUMBER(7)
     CONSTRAINT fk_seq_intrhist  ON DELETE CASCADE
     *
     ORA-02253: constraint specification not allowed here  ... is the message.

Do I have to drop/recreate the table...or is my command syntax incorrect?

Thanks,
Don
 
  Received on Tue Jul 27 1999 - 23:09:04 CEST