Re: Cascade deleting

"erton" <aerton_at_poczt.onet.pl> a écrit dans le 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
>

If you have a primary key on the column id you can add a foreign key:

alter table my_table add constraint fk foreign key (parentid) references my_table (id) on delete cascade;

--
Have a nice day
Michel