Unique constraint properties (DB2)

Use the Properties view to modify the properties of a DB2® unique constraint.

For more information about DB2 syntax, see the reference information that is included with each product. There may be differences between DB2 syntax and the syntax for other vendors.

General page
Property Description
Name Type a name.
Label Type a label. This label is displayed in visual diagrams.
Deferrable Specify whether constraint checking is deferred until the end of a transaction. This option is only available for databases that support deferred constraint checking.
Schema Shows the relational schema under which this object was created.
Members page
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
Type information about the object.
Annotation page
Add or delete properties and edit their values.

Feedback