Question Locked

SQL DELETE -- MULTIPLE TABLES

0 helpful

2 replies

by arunrajr Aug 20, 2007 last reply Aug 20, 2007

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

HOW TO DELETE ROW FROM MULTIPLE DEPENDENT TABLEW WITH REFERENTIAL INTEGRITY...?

2 replies

Clarifications

it's an option called cascading deletes.
It's one of the parameters of the foriegn key.

Then if you delete a record from the master table, all the corresponding detail ones go as well.

Have a good think about where you use it. A wee error and you are reaching for a backup tape.

This discussion is closed to new replies.