Unique constraint properties

Properties for IBM® data server unique constraint objects

For more information about unique constraint syntax, see the reference information that is included with each database product. There might be differences between the IBM data server syntax and the syntax for other vendors.

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.
Related information
Unique constraints, Version 9.1 for z/OS
Adding unique constraints, DB2 Version 9.1 for Linux, UNIX, and Windows
Using the UNIQUE or DISTINCT constraints, IBM Informix Dynamic Server v10.0

Feedback