On Delete Cascade in same Table possible? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

On Delete Cascade in same Table possible?

Hello, I’m just working on a project-administration tool and it should be possible to create sub-projects from each project (id, parentid relation). Now i need the functionality to recursively delete a project completely or from a project-level the user selected. I thought it would work with the "On Delete Cascade" constraint, but Sql-Server doesn’t allow me to set this contraint on the own table (it’s greyed out).
Why ist this function deactivated, there should be no problem to recursively delete sub-entries from the same table? thanks in advance.
pete
Implement in trigger.
]]>