What do you mean by Cascading Referential Integrity Constraints?
Right now only two new clouses are there, Which is : ON DELETE and ON UPDATE clauses in the REFERENCES clause of the CREATE TABLE and ALTER TABLE statements.
The ON DELETE and ON UPDATE clauses have two options:
� NO ACTION : NO ACTION specifies that the deletion/updation fail with an error.
� CASCADE : CASCADE specifies that all the rows with foreign keys pointing to the deleted/updated row are also deleted / updated.
> ON DELETE : Its bassically controls what actions are taken if we attempt to delete a row to which existing foreign keys point.
> ON UPDTE : It is bassically defines the actions that are taken if we attempt to update a candidate key value to which existing foreign keys point.