| Domain |
Specifies a domain data type for the column. You must
associate a domain model with the data design project or define domains in
a physical model to see domain data types in this list. |
| Data type |
Specifies a base data type for the column. |
| Precision |
Specifies a precision for the column. Only available
if the data type requires a precision specification. |
| Length |
Specifies a length for the column. Only available if
the data type requires a length specification. |
| Scale |
Specifies a scale for the column. Only available if
the data type requires a scale specification. |
| Expression |
Specifies an expression for the column. Available only
if Generated is selected. |
| Default value |
Specifies a default value for the column. Available
only if Generated is not selected. |
| Primary Key |
Designates a column as a primary key column. |
| Not Null |
Specifies that the column cannot contain null values. |
| Generated |
Designates that values for this column are generated
by the DB2® database
system. |
| Start value |
Specifies a value for the START WITH clause. Available
only if Generated is not selected. |
| Increment |
Specifies a value for the INCREMENT BY clause. Available
only if Generated is not selected. |
| Minimum |
Specifies a value for the MINVALUE clause for an identity
column. Available only if Generated is not selected. |
| Maximum |
Specifies a value for the MAXVALUE clause for an identity
column. Available only if Generated is not selected. |
| Cycle |
Specifies whether an identity column continues to generate
values after reaching either its maximum or minimum value. Specifies the CYCLE
option. Available only if Generated is not selected. |
| Cache |
For an identity column, specifies how many values of
the identity sequence are to be pre-allocated and kept in memory. When values
are generated for the identity column, pre-allocating and storing values in
the cache reduces synchronous I/O to the log. |