If a FOREIGN KEY constraint exists,then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table.

Question

If a FOREIGN KEY constraint exists,then a record cannot be deleted from the parent table if that row is referenced by an entry in the child table.​

Quizplus · Accepted Answer

This is the basic functionality of a FOREIGN KEY constraint in a relational database management system. It ensures referential integrity by preventing orphaned records in the child table. If a record is deleted from the parent table, then the corresponding rows in the child table also need to be deleted, or the foreign key constraint needs to be temporarily disabled.

If a FOREIGN KEY Constraint Exists,then a Record Cannot Be