What is cascading delete and cascading update ?
Cascading Delete and Cascading Update :-
Referential integrity is a feature of relational database management system. Let table B has a foreign key that point to a field in table A. If a record be deleted from table A, recorders of table B that are linked to the deleted record will also be deleted. This is known as cascading delete.
Further if the value of a linked field in the table A be modified, all records in table that are linked to it also be modified accordingly. This is Known as cascading update.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment