Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.server -> existing FK, modify to add "ON DELETE CASCADE"

existing FK, modify to add "ON DELETE CASCADE"

From: Anna C. Dent <anacedent_at_hotmail.com>
Date: Sat, 08 May 2004 08:26:55 -0700
Message-ID: <3%6nc.94015$Jy3.36491@fed1read03>

What is the proper SQL syntax to modify an EXISTING foreign key constraint to add "ON DELETE CASCADE" to it? Received on Sat May 08 2004 - 10:26:55 CDT

This message: [ Message body ]
Next message: juan: "help with fields BLOB"
Previous message: Mike Ault: "Re: About ORA-01658 unable to create INITIAL extent for segment in tablespace <ts>"
Next in thread: Marc Blum: "Re: existing FK, modify to add "ON DELETE CASCADE""
Reply: Marc Blum: "Re: existing FK, modify to add "ON DELETE CASCADE""
Reply: Anurag Varma: "Re: existing FK, modify to add "ON DELETE CASCADE""

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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