Why does access support the Cascade update related fields option?



Why does access support the Cascade update related fields option?

For this reason Access supports the Cascade Update Related Fieldsoption. When you enforce referential integrity and choose the Cascade Update Related Fieldsoption, and you then update a primary key, Access automatically updates all fields that reference the primary key.

What is update cascade in SQL?

UPDATE CASCADE: When we create a foreign key using UPDATE CASCADE the referencing rows are updated in the child table when the referenced row is updated in the parent table which has a primary key. We will be discussing the following topics in this article:

What are delete Cascade and update cascade rules in SQL Server foreign key?

In this article, we will review on DELETE CASCADE AND UPDATE CASCADE rules in SQL Server foreign key with different examples. DELETE CASCADE: When we create a foreign key using this option, it deletes the referencing rows in the child table when the referenced row is deleted in the parent table which has a primary key.

What is Cascade delete related records in access?

For this reason, Access supports the Cascade Delete Related Records option. When you enforce referential integrity and choose the Cascade Delete Related Records option, and you then delete a record on the primary key side of the relationship, Access automatically deletes all records that reference the primary key.