Ensuring Referential Integrity
Question

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!

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.

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.

Hi Quinten,

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

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