How do I delete rows from different tables atomically?
Table A has a primary key and foreign key into Table B.
Asked
Active
Viewed 247 times
1 Answers
6
The standard solution is to use ON DELETE CASCADE for your constraint. Search for 'cascade' on that page.
If that is not an option, this SO question may interest you: In SQL Server 2005, can I do a cascade delete without setting the property on my tables?
