Log in to AnswerLog in to Follow
2021-07-02 15-28-30
Quinten
7Views
3Comments
Solved
Ensuring Referential Integrity
Question
Data

Hi All,

I am trying to understand how and why some Delete Rules ensure referential integrity. 
Can anyone explain what internally happens when we set the Delete Rule of our foreign key? 

Thanks!

0
0
27 Jul

Hi,

When you set the Delete Rule to Protect/Delete, the indexes are automatically generated for those foreign keys and they support Referential Integrity then.

Only the Delete and Protect Delete Rules protect Referential Integrity. Ignore doesn't.

See solution in context
0
0
27 Jul

Hi,

When you set the Delete Rule to Protect/Delete, the indexes are automatically generated for those foreign keys and they support Referential Integrity then.

Only the Delete and Protect Delete Rules protect Referential Integrity. Ignore doesn't.

0
0
27 Jul

Hi Quinten,

I think this document has explained it very clearly with example, please check it Doc Link

0
0
27 Jul
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.