Re: Cascade deleting

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 24 Sep 2001 15:38:57 +0100
Message-ID: <3baf4586$0$227$ed9e5944@reading.news.pipex.net>

You would need 2 tables

One with parents and one with children.

You can then use triggers or standard referential interity constraints.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"erton" <aerton_at_poczt.onet.pl> wrote in message
news:9onf56$bvh$1_at_news.onet.pl...


> Hi

>

> I have a table, which is composed of two fields:

> -ID

> -ParentID

> I would like to make cascade deleting (deleting record with ID x cause

> deleting all records which have ParentID equal to x). How can I do it? I

> have tried to do it in a trigger and by constraints but it doesn't work.

>

> Thanks

>

>

>

>

Received on Mon Sep 24 2001 - 09:38:57 CDT