Check Constraints Editor (IBM DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for z/OS Object Editors

The Check Constraints Editor lets you view definition details and edit a check condition expression.

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

Lets you view basic identification information on the check constraint: Table Schema and Table Name, the Name of the constraint and the date it was Created. You can also edit the condition in the Check Condition box. The Table Columns button acts a time saver in editing the condition. It opens a dialog that lets you select and paste column names into the check condition expression.

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.