Changing check constraints when altering a table

Use the Change Check Constraints window to alter check constraints for your table. A check constraint sets restrictions on data added to the table. Check constraints are enforced when rows in the table are inserted or updated.

Fields and controls

Authorities and privileges



To alter a check constraint:

  1. Optional: Change the check condition by typing a new condition in the Check condition box.
  2. Optional: Change the name of the constraint by typing a new name in the Constraint name field.
  3. Optional: In the Comment field, type a new comment for the check constraint or edit the existing comment.
  4. Click on OK to make the changes you specified for the check constraint and close the Change Check Constraint window.
  5. If you do not want to make any additional changes to the table, click on OK to alter your table and close the Alter Table notebook. Otherwise, continue on to one or more of the optional tasks.


Related information