Unique constraint properties

Properties for IBM® data server unique constraint objects

For more information about specific syntax, see the reference information that is included with each database product. Syntax definitions for some database vendors or versions might differ from the following descriptions.

General page
Property Description
Name Specifies a name for the object.
Label Specifies a label that is displayed in visual diagrams.
Schema Shows the relational schema under which the object was created.
Deferrable Specifies whether constraint checking is deferred until the end of a transaction. This option is only available for databases that support deferred constraint checking.
Members page
In edit mode, use the grid and the toolbar buttons on this page to add, delete, and change the order for columns.
  • Click the ellipsis [...] button to open a window so that you can specify which columns are included in the unique constraint.
  • Select a column in the grid and click Move Column Up or Move Column Down to change the order of columns.
Property Description
Column Shows the column name.
Data type Shows the data type for the column.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.

Feedback