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

The constraint name is an SQL long identifier. The check condition defines the actual constraint logic ... This constraint ensures that the EMPO column can contain values that range from 100 to 25000 ...

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.