Existing constraint

[rshivagami]

Hi all,

Is there any way I could change an existing constraint and add 'Delete cascade' option without dropping & recreating it ?

Shiva.

[tamilselvan]

DELETE CASCADE is part of CREATE TABLE Statement.
So, you cannot add it later.

[jmodic]

On existing constraint you can only change its state (DEFERRABLE, IMMEDIATE/DEFERRED) with "ALTER TABLE ... MODIFY CONSTRAINT ..." without droping and re-creating the constrain. For every other change, including DELETE CASCADE, you have to drop existing constraint and add a new one with "ALTER TABLE DROP/ADD CONSTRAINT ...".