Changing check constraints when altering a table

Use the Check Constraints page of the Alter Table notebook 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.

You can alter or drop existing check constraints. To drop a check constraint, select the check constraint that you want to drop from the Check constraints box and click on Remove.

Before you begin...

To alter a check constraint:

1. Open the Alter Table notebook.

2. Click on the Check Constraints tab.

3. In the Check constraints box, select the check constraint that you want to change.

4. Click on Change. The Change Check Constraint window opens.

5. Optional: Change the check condition by typing a new condition in the Check condition box.

6. Optional: Change the name of the constraint by typing a new name in the Constraint name field.

7. Optional: In the Comment field, type a new comment for the check constraint or edit the existing comment.

8. Click on OK to make the changes you specified for the check constraint and close the Change Check Constraint window.

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

• Check constraints -- See the SQL Reference
• Check conditions -- See the SQL Reference

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]