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.