How to modify a CHECK constraint (Enterprise Manager)

To modify a CHECK constraint

  1. Expand a server group; then expand a server.
  2. Expand Databases, expand the database in which the table belongs, and then click Tables.
  3. In the details pane, right-click the table, and then click Design Table.
  4. Right-click the column name containing the CHECK constraint; then click Properties.
  5. Click the Tables tab.
  6. Click the constraint you want to change in the Selected constraint list.
  7. Complete an action from the following table.
To Follow these steps
Edit the constraint expression Type the new expression in the Constraint expression box.
Rename the constraint Type a new name in the Constraint name box. Make sure that your new name doesn’t duplicate a name in the Selected constraint list.
Apply the constraint to existing data Select the Check existing data on creation option.
Disable the constraint when new data is added to the table or when existing data is updated in the table Clear the Enable constraint for INSERT and UPDATE option.
Disable the constraint when the table is replicated in another database Clear the Enable constraint for replication option.

See Also
Creating and Modifying CHECK Constraints How to modify a CHECK constraint using a database diagram

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.