sql server 2005 - on delete cascade 1

[tperri]

hi everyone,

I have a table that has already been created. Its a user table, and i have other tables with child records that need deleted when i delete a user. I'm reading that the on delete cascade is what I need to use, but I dont know how to implement it. Can anyone help me with this?

Thanks in adavance!
T

 

[disord3r]

I don't think it matters much that the table already exists, as I've been able to do this after the fact to applications that another developer created.

The easiest way I've found is to use the database diagram capabilities in Enterprise Manager from SQL 2000 client tools. As you create foreign key relationships by literally dragging connections between the columns in your different tables that have related data, you can go to the properties of a given relationship and enable cascading updates and deletes.

http://www.functionx.com/vcsharp/databases/Lesson01.htm

Look towards the bottom for diagrams and foreign keys.

 

[disord3r]

Ignore the fact that I mentioned SQL 2000. I forgot you mentioned 2005 specifically, but you can do this in 2k5 as well via the SQL Management Studio.

 

[tperri]

I'll give this a try, thank you

 

[ESquared]

See Delete records from 2 tables in one query.

[COLOR=black #d0d0d0]My alarm clock causes time travel. When I hit snooze, no apparent time passes before the alarm sounds again, but the universe has in fact moved forward through time by ten minutes![/color]