Re: Cascading Deletes

I think a references constraint on ID
referencing _ID with ON DELETE CASCADE
should do what you want.

Stephan Szabo
sszabo@bigpanda.com

On Wed, 6 Sep 2000, Craig May wrote:

> Hi,
> 
> I have a tables having this structure:
> 
> ID (int) | _ID (int) | Name (String)
> 
> 
> _ID is the parent of ID.
> 
> I'm looking for the best method to perform a cascade delete.  For example, I
> delete _ID, it in turn deletes ID, and should ID also be an entry within _ID, it
> would continue through the chain.
> 
> For example:
> 
> 0 0 Base
> 1 0 Sib1
> 2 0 Sib2
> 3 0 Sib3
> 4 1 Sib1_1
> 5 1 Sib1_2
> 
> 
> Deleting Base would remove all the entries.  Deleting Sib1 would delete Sib1_1
> and Sib1_2.
> Can anyone help out here?
> 
> Regards,
> Craig May
> 
> Enth Dimension
> http://www.enthdimension.com.au
>