sql: delete a subtree table(id, Parentid) , delete a item with all his children
- by Omu
I have a table like this
foo(id, parentId)
-- there is a FK constraint from parentId to id
and I need to delete an item with all his children and children of the children etc.
anybody knows how ?