Respuesta :
The records in the related table be updated or deleted by cascade delete. Using the cascading delete option, you can delete a record from one table and have the associated entries in the other table also be destroyed.
When a record in the parent table is deleted, a foreign key with cascade delete ensures that the relevant records in the child database are also deleted automatically. In SQL Server, this is referred to as a cascade delete.
Either a CREATE TABLE or ALTER TABLE statement can be used to create a foreign key with cascade delete.
Users can remove records even if they don't have access to them when the target lookup record is deleted because cascade-delete bypasses security and sharing settings. Cascade-delete is disabled by default to avoid unintentional record deletion. To enable the "Enables cascade delete on custom lookup relationships" option for your company, get in touch with Salesforce Support.
To know more about cascade delete click here:
https://brainly.com/question/28903418
#SPJ4
