Column Definitions, Designer

Table Definition

In this section, you provide the basic information for the table.

Table name

Type a name for the table. This name can be 1-128 characters, and can either be an ordinary identifier or a delimited identifier.

Table schema

Type or select the schema for the table.

Comment

Type one or more comments about the table. The comments that you type here are appended to the generated table script.

Table space

Specify the table space in which to create the table. A table space is a large database that is partitioned into separate managed parts.

Owner

Type the user ID of the owner of the table.

Dbspace

Type the name of the dbspace in which the table exists.

Columns

In this section, you specify the column or columns that you want to define as part of the table.

Name

Type a name for the column. This name can be an ordinary identifier or a delimited identifier. You cannot use the same name for more than one column in the table. This name must be unique within the table.

Type

Select the data type of the column. The default data type is VARCHAR, with a default length of 256 characters.

For data types of DECIMAL or FLOAT, specify values for precision and scale, as appropriate, in the Column Properties section.

(DB2^® Version 9.7 for Linux^®, UNIX^®, and Windows^®, or later; DB2 for z/OS^®)
Optional: For the data type of TIMESTAMP or TIMESTAMP WITH TIMEZONE [DB2 for z/OS Version 10 new function mode (NFM) only], specify the value for the precision in the Column Properties section. The default value is 6 microseconds.

Length

If you selected a data type of CHARACTER, VARCHAR, BLOB, CLOB, DBCLOB, GRAPHIC, or VARGRAPHIC, type the length (byte count) of the column.

Allow Nulls

Select this check box to specify that the column can contain null values. If the column is a primary key column, it cannot contain null values.

Comment

Type one or more comments for the column. The comments that you type here are appended in the generated script.

Opens the Import window so that you can import columns from one or more tables into the table.

Column Properties

In this section you change or specify the properties for the column that is selected in the Columns section. An unavailable property is a limitation of the database that you are using.

Select a property to see its description in the box under the properties list. If the description exceeds the size of the box, hover the mouse pointer over the last line of text in the box. After a brief pause, the full description is shown in a ScreenTip.