Is it possible to add a Foreign key (FK) constraint and not have anything to happen upon delete of row affected by the FK?
What I mean is that I would like to disable the ON DELETE clause.
I'm working on an old system where I would like to add FK as information/documentation as a first step.
The next step would be to add checks for correct values, by enabling the constraint.
The latest step would be to add the DELETE clause.
Some logic will not work and must be changed in order to add the ON DELETE clause.
Regards
Håkan