Domain |
Select a domain data type for the column. You must associate
a domain model with the data design project or define domains in your physical
model to see domain data types in this list. |
Generated column |
Select to designate that values for this column are
generated by DB2.
The properties on this page change depending on whether you specify this option. |
Data type |
Select a base data type for the column. |
Precision |
Specify a precision for the column. Only available if
you select a domain or base data type that requires a precision specification. |
Length |
Specify a length for the column. Only available if you
select a domain or base data type that requires a length specification. |
Scale |
Specify a scale for the column. Only available if you
select a domain or base data type that requires a scale specification. |
Expression |
Specify an expression for the column. Available only
if Generated Column is selected. |
Default value |
Specify a default value for the column. Available only
if Generated Column is not selected. |
Primary Key |
Select to designate a column as a primary key column. |
Not Null |
Select to prevent the column from containing null values. |
Identity |
Select to designate the column as an identity column.
If you select Generated Column, the column is generated
as an identity column. If you do not select Generated Column,
additional fields are available on this page so that you can specify additional
identity column attributes. |
Start value |
Type a value for the START WITH clause. Available only
if Identity is selected and Generated Column is
not selected. |
Increment |
Type a value for the INCREMENT BY clause. Available
only if Identity is selected and Generated
Column is not selected. |
Minimum |
Type a value for the MINVALUE clause. Available only
if Identity is selected and Generated Column is
not selected. |
Maximum |
Type a value for the MAXVALUE clause. Available only
if Identity is selected and Generated Column is
not selected. |
Cycle |
Select to specify the CYCLE option. Available only if Identity is
selected and Generated Column is not selected. |