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.

The next SQL*Plus snippet demonstrates this in ... for a given table that are foreign key constraints and which primary key constraints they depend on. set linesize 180 set verify off accept ...