SQL changing an existing constraint
Here is a constraint I have
CONSTRAINT CURRENTPLAN_FK FOREIGN KEY(CurrentPlanCode) REFERENCES PLAN(CurrentPlanCode),
I'd like to include
ON DELETE CASCADE
in that constraint.
How can i change the existing CURRENTPLAN_FK constraint to include
ON DELETE CASCADE
in CURRENTPLAN_FK
Assume CURRENTPLAN_FK belongs to the CURRENTPLAN table