Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> On Delete Cascade

On Delete Cascade

From: Sonia Gillespie <sonia_gillespie_at_lagan.com>
Date: 2000/07/11
Message-ID: <963315402.658.0.nnrp-09.9e9859ae@news.demon.co.uk>#1/1

I would like to know if it is possible to add the 'on delete cascade' to a foreign key that has already been defined in a table? Or do I have to drop the foreign key and recreate the whole constraint?

I'm using Oracle 7.3.4.

Thanks,

--
Sonia Gillespie
E-mail: sonia_gillespie_at_lagan.com
Received on Tue Jul 11 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US