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 use ... this simple query shows the constraints for a given table that are foreign key constraints and which primary key constraints they depend ...

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

SQL Server 2000<BR><BR>I need to change the ... HR></BLOCKQUOTE><BR><BR>It lists a bunch of constraints. Now I'm assuming I can drop all the constraints, change collation, and then add them ...