Sorry, you have to drop and recreate the constraint;
there is no way to add the "on delete cascade" clause.
--
Have a nice day
Michel
Sonia Gillespie <sonia_gillespie_at_lagan.com> a écrit dans le message :
963315402.658.0.nnrp-09.9e9859ae_at_news.demon.co.uk...
> 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
