Check Constraints Editor (IBM DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The Check Constraints Editor lets you modify and enable/disable check constraints.

To edit a check constraint:

  1. Open an editor on the check constraint. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Definition

Use the Enabled control to enable/disable the check constraint. You can also edit the condition in the Check Condition box. The Table Column button opens a dialog that lets you select and paste column names into the check condition expression.

Comment

For details on using this tab, see Adding a Comment to an object.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.