Enforcing hierarchial tree integrity

I have some tables that store hierarchical data, just wondering what is a good way to enforce integrity on the database side.

The problem, deleting a node with children will result in the orphaning of those nodes. It's easy enough to do client-side but what I'd like to do is keep the integrity logic on the server-side.

Basically, when a node is deleted then all of it's children (if any) should get deleted too. I suspect this needs to be done using a delete trigger.

Just thought I'd run it by this group in case anyone has already done this. Received on Thu Jul 28 2005 - 15:20:09 CDT