Showing how the DELETE CASCADE clause works and why you might not want to be tempted by it
Constraints
Having been bitten by the delights of a Foreign Key(FK) with NOCHECK I thought it time to do a little digging. I’ve always been aware of the perils of this option but have encountered a table with this feature and I was caught out by it. I’m also aware of the impact it can have …
Notes on SQL 