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.

To define a referential constraint, you must create a primary key in the parent table and a foreign key in ... for both planned application programs and for queries in ad hoc SQL statements and BI ...