Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: existing FK, modify to add "ON DELETE CASCADE"
"Anna C. Dent" <anacedent_at_hotmail.com> wrote in message news:3%6nc.94015$Jy3.36491_at_fed1read03...
> What is the proper SQL syntax to modify an EXISTING
> foreign key constraint to add "ON DELETE CASCADE" to it?
I don't believe there is a way except drop and recreate.
Anurag Received on Sat May 08 2004 - 11:24:07 CDT