NO ACTION just means to take NO ACTION to make the FK constraint valid. This does not prevent the deletion of the parent from failing if there are children and foreign key enforcement is enabled.
NO ACTION just means to take NO ACTION to make the FK constraint valid. This does not prevent the deletion of the parent from failing if there are children and foreign key enforcement is enabled.