Hi all

i would like to know if this is possible

how to temporarily disable on delete cascade but not the constraint

i want to delete a row from the primary key table but i dont want the data from the foreign key to be deleted even though there is an on delete cascade set.

how do i temporarily disable on delete cascade from firing without disabling the constraint


Rgrds