There are four delete actions:
None: A None delete action will delete selected row in a table but nothing occurs to the
table that relate to this table.
Cascade: A Cascade delete action will delete all the records in the related table,
i.e, deleting the parent record will also delete child record in the related table.
Restricted: A Restricting delete will raise an error message if the user tries to delete a record,
where records exists in related table where the foreign key is equivalent to the primary key
of the current table.
Cascade + Restricted: The delete action performs an restricted, if the record of the table will
be deleted directly and performs an cascade, if the record of the table will be deleted through
a cascade delete action of a database.
None: A None delete action will delete selected row in a table but nothing occurs to the
table that relate to this table.
Cascade: A Cascade delete action will delete all the records in the related table,
i.e, deleting the parent record will also delete child record in the related table.
Restricted: A Restricting delete will raise an error message if the user tries to delete a record,
where records exists in related table where the foreign key is equivalent to the primary key
of the current table.
Cascade + Restricted: The delete action performs an restricted, if the record of the table will
be deleted directly and performs an cascade, if the record of the table will be deleted through
a cascade delete action of a database.
No comments:
Post a Comment