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. Skip ...

If a primary key value is updated, three options exist for handling foreign key values: (1) Restricted UPDATE. The modification of the primary key column(s) is not allowed if foreign key values exist; ...