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.