SQL - Table Constraints
What happens to child rows when a parent row is deleted if the foreign key is defined with
ON DELETE RESTRICT?What happens to child rows when a parent row is deleted if the foreign key is defined with ON DELETE RESTRICT?
easy📝 Conceptual Q1 of 15
Step-by-Step Solution
Solution:
Step 1: Understand ON DELETE RESTRICT behavior
ON DELETE RESTRICT prevents deletion of a parent row if any child rows reference it.Step 2: Apply to the scenario
If child rows exist, the parent row cannot be deleted, so the delete operation is blocked.Final Answer:
The delete operation on the parent row is blocked if child rows exist. -> Option DQuick Check:
ON DELETE RESTRICT = Block delete if children exist [OK]
Quick Trick: RESTRICT blocks parent delete if children exist [OK]
Common Mistakes:
MISTAKES- Thinking child rows get deleted automatically
- Assuming foreign keys are set to NULL
- Believing parent deletes always succeed
Master "Table Constraints" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes