Hi!

Use foreign key with CASCADE delete rule.

--- In firebird-support@yahoogroups.com, Nols Smit <nols@...> wrote:
>
> Hi,
>
> I'm using FireBird 2.5
> I have a table with hierarchical data.
> A column "Parent_Id" that holds the Id ("ID" - the primary key column) of it's parent.
>
> When deleting a row, I want to delete, using recursive CTE, all children (all levels of nesting).
> How to do it?
>
>
> Regards
>
> Nols Smit
>
>
> [Non-text portions of this message have been removed]
>