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

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

I have a foreign key constraint that I created to reference the primary key of another table:<BR><BR><pre class="ip-ubbcode-code-pre">constraint geneassay_fk foreign ...