Column grid

Displays the columns defined for a given object. Columns headings are as follows:

Column name
The SQL name of the column.

Short name
The system name of the column.

Data type
The data type of the column. For a list of built-in data types, see Data types. Columns can also be a distinct type.

Length
The length of the column.

Nullable
Whether the column is nullable.

Default value
The default value of the column.

Text
The description of the column.

CCSID
The value of the CCSID of the column.

Is identity
Whether the column is an identity column.

Allocate
The space allocated for the column in each row.

Heading 1
The value of Heading 1.

Heading 2
The value of Heading 2.

Heading 3
The value of Heading 3.

Order
For an index, the order that the column is in. Possible values are Ascending or Descending.