What is ON DELETE CASCADE?

Answer Posted / tulsi

The main use of ON DELETE CASCADE is to delete the child
records automatically from a table when the related records
from master table is deleted.

Assign the ON DELETE CASCADE clause while creating the
foreign key

Is This Answer Correct ?    17 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is scope and visibility in PL/SQL?

769


How many types of normalization are there?

669


What are the advantages of sql? Explain

850


What is replication id?

683


Why do we use %rowtype & %type in plsql?

786






Explain the the update statement in sql?

770


how to drop an existing view in mysql? : Sql dba

792


Define overloaded procedure?

803


What is a crud api?

684


How do I edit a trigger in sql developer?

705


What are the datatypes available in pl/sql ?

793


Is sql a backend language?

844


Explain what is sql*plus?

855


Explain the commit statement.

848


what are the differences between require and include, include_once and require_once? : Sql dba

743