When/Why to use Cascading in SQL Server?
Posted
by Joel Coehoorn
on Stack Overflow
See other posts from Stack Overflow
or by Joel Coehoorn
Published on 2008-09-12T15:27:36Z
Indexed on
2010/05/27
20:31 UTC
Read the original article
Hit count: 182
When setting up foreign keys in SQL Server, under what circumstances should you have it cascade on delete or update, and what is the reasoning behind it?
This probably applies to other databases as well.
I'm looking most of all for concrete examples of each scenario, preferably from someone who has used them successfully.
© Stack Overflow or respective owner