How to modify a CHECK constraint using a database diagram (Enterprise Manager)

To modify a CHECK constraint using a database diagram

  1. Open a database diagram.
  2. Right-click the table whose check constraint you want to modify, and then click Properties.
  3. Click the Tables tab.
  4. Click the constraint you want to change in the Selected constraint list.
  5. 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 open a database diagram

  


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