State the purpose of ON UPDATE CASCADE Note however that Ora

State the purpose of ON UPDATE CASCADE. Note, however, that Oracle does not support this command.

Solution

Solution:

By using cascade referential integrity constraints we can define the actions to the SQL Server. By using this we can try to update or delete the key to which existing foreign keys point. If there are two tables, then the relationship between the two tables can be defined by the foreign key. Any cascading update or delete statements can be done by using the foreign key. If an update statement affects rows in the foreign key table, the rows will be updated. The primary key record will be updated first, and then using these values the foreign key table rows will be updated.