Column properties

Properties for IBM® data server column objects

For more information about column 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.
Type page
Property Description
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.
Documentation page
Specifies user-supplied information about the object.
Annotation page (in edit mode only)
Add, modify, or delete properties.
Related information
CREATE TABLE statement syntax, Version 9.1 for z/OS
CREATE TABLE statement syntax, DB2 Version 9.1 for Linux, UNIX, and Windows
CREATE TABLE statement syntax, IBM Informix Dynamic Server v10.0

Feedback