SQL Server Performance

On Delete Cascade in same Table possible?

Discussion in 'SQL Server 2005 General DBA Questions' started by petewulf, Aug 28, 2005.

  1. petewulf New Member

    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
  2. Adriaan New Member

    Implement in trigger.

Share This Page