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@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 - 16:09:04 CDT