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. |