The concept of changing the way you view constraints was laid out in the book A Beautiful Constraint: How To Transform Your ...

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.