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 minus?

548


is mysql query is case sensitive? : Sql dba

566


What is difference between function and trigger?

546


Why cannot I use bind variables in ddl/scl statements in dynamic sql?

670


How many types of indexes are there in sql?

537






What is number function in sql?

531


does sql support programming? : Sql dba

611


Do we need to create index on primary key?

470


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

541


How does a self join work?

521


How to place comments in pl/sql?

607


What is sqlite used for?

533


Explain what is a subquery ?

656


What is sql engine in oracle?

525


Can a procedure in a package be overloaded?

549