How do I edit a table in order to enable CASCADE DELETE?

RadiantHex picture RadiantHex · Dec 15, 2010 · Viewed 45.2k times · Source

I have a table representing users. When a user is deleted I get:

DELETE statement conflicted with the REFERENCE constraint

Apparently, CASCADE DELETE is not as easy as I imagined in SQL Server, and the option needs to be added to the table.

The problem is: I cannot figure out how to add the CASCADE DELETE option.

I'm using: SQL Server 2008. Any ideas how to do this?

Answer

RC_Cleland picture RC_Cleland · Dec 15, 2010

Read this Microsoft article first. Read Me. I use the GUI during design so here is a picture of how it is selected in SSMS. alt text The syntax added to the foreign key is " ON DELETE CASCADE "