Database - Introduction to SQL - Discussion

These are easily understandable explanations. Thanks all.

Delete or update the row from the parent table, and automatically delete or update the matching rows in the child table.

Both ON DELETE CASCADE and ON UPDATE CASCADE are supported.

Specifying RESTRICT (or NO ACTION) is the same as omitting the ON DELETE or ON UPDATE clause.

Thanks for the explanation @Gayatri.

Thanks for all to give the better explanation.

ON UPDATE CASCADE indicates that if we update the parent, then the change is cascaded (affected) to the child easily.
However, Data integrity means maintaining and assuring the accuracy and consistency of data over its entire life-cycle. Therefore, Cascade directly leads to data integrity.

For Example: If you delete a company, you might also want to delete the company's history of addresses.

In oracle parent-child relation table is there on that time you delete the parent record or row then it shows error.

It means the parent table is associated with a child that why the parent record not delete. If u delete the parent records before we drop the child table record, it is not possible to the real time that why we are using cascade keyword mention in child table creation otherwise you drop the parent time use.

EX: Drop table parent table name cascade.

If we apply cascade property then we can perform delete, update operation even if primary key and foreign keys are applied to main and child table.

Cascade means whenever you will perform any modification in a data that has its key as a foreign key in another table.

The same modification will be performed in the another tables on rows which have that foreign key.

The accuracy and consistency of stored data, indicated by an absence of any alteration in data between two updates of a data record. Data integrity is imposed within a database at its design stage through the use of standard rules and procedures, and is maintained through the use of error checking and validation routines.

And by the means of cascade it is ensured that all the related table which contain the updated data will be updated when an row is updated. And the effect would be reflected.

How actually the data integrity is ensured in the cascade?