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.

And, in most cases, the application logic will be less efficient than the built-in DBMS logic. Furthermore, simply failing to code the referential constraints ... data integrity for both planned ...