Is there any way I could change an existing constraint and add 'Delete cascade' option without dropping & recreating it ?
DELETE CASCADE is part of CREATE TABLE Statement.
So, you cannot add it later.
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 ...".
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
Click Here to Expand Forum to Full Width