Currently you can't change the ON DELETE action or ON UPDATE action of an
existing constraint. You have to drop the constraint and create it again
with the action you want. This is not a light-weight activity, as it has
to validate the new constraint.
Is there a fundamental reason that ALTER TABLE...ALTER CONSTRAINT cannot
change the action? Or is just that no one got around to it?
Cheers,
Jeff