Use the Change Column window to modify new columns for the table that
you're altering. You can change any field of any column you have
added until you click on OK.
Fields and controls

To change a new column:
- Make any of the following changes to the column definition:
- Change the name of the column by typing a new name in the Column name field.
- Use the Data type box to specify a
different data type.
- If the data type of the column is CHARACTER, VARCHAR, BLOB, CLOB, DBCLOB,
GRAPHIC, or VARGRAPHIC, change the length of the column by typing a new length
in the Length field.
- If the data type of the column is BLOB, CLOB, or DBCLOB, use the LOB unit box to specify a new multiplier for the
length of columns.
- If the data type of the column is DECIMAL:
- In the Precision field, type the new
precision (total number of digits) for the column.
- In the Scale field, type the new scale
(number of digits to the right of the decimal) for the column.
- If the data type of the column is BLOB, CLOB, DBCLOB, or a distinct type
with any of these as source types, specify the LOB options by selecting or
clearing the appropriate LOB option check
boxes.
- If the data type of the column is CHARACTER, VARCHAR, or LONG VARCHAR,
select or clear the Bit data check box to
specify whether the contents of the column be treated as bit (binary)
data.
- In the Default field, type a new default
value for the column.
- Select or clear the Nullable check box to
indicate whether you want to allow the column to contain null values.
- Optional: In the Comment field,
type a new comment or edit the existing comment.
- Click on OK to make the changes you specified for the column
and close the Change Column window.
- If you do not want to make any additional changes to the table, click on
OK to alter your table and close the Alter Table notebook.
Otherwise, continue on to one or more of the optional tasks.

Related information
- Alter Table -- Overview
- Data types -- See the SQL Reference
- LOB units -- See the SQL Reference
- Default values -- See the SQL Reference
- Null values -- See the SQL Reference