Actions prevented once referential integrity is enforced

What is the actions prevented once referential integrity is enforced?

Following are the actions prevented once referential integrity is enforced.

We can't add records to a related table if there is no associated record in the primary table
We can't change value in a primary table that has corresponding records in the related table.
We can't delete records from a primary table if there are related records in the foreign table

What is the actions prevented once referential integrity is enforced?

Actions prevented are:
- Breaking of relationships is prevented once referential integrity on a database is enforced.
- Can’t delete a row from primary table if there are related rows in secondary table.
- Can’t update primary table’s primary key if row being modified has related rows in secondary table.
- Can’t insert a new row in secondary table if there are not related rows in primary table.
- Can’t update secondary table’s foreign key if there is no related row in primary table.