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. |
Allocate |
For DB2 for i5/OS® columns only: Specifies
for VARCHAR, VARGRAPHIC, VARBINARY, XML, and LOB types the space to
be reserved for the column in each row. |
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. |
Default constraint name |
Specifies a name for the constraint. Available
only if a default value is already specified. |
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. |