This is the purpose of the clause `ON DELETE SET NUL` Of course, if you do not want to set the referent to NULL and instead let it be invalid, then what you are discussing is not a foreign key since the very definition of a foreign key requires the existence of a parent for each child except when the child is NULL.