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

Question

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 1

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. The syntax added to the foreign key is " ON DELETE CASCADE "