Changing new columns when altering a table

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.

To change a new column:

1. 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:

     1. In the Precision field, type the new precision (total number of digits) for the column.

     2. 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.

2. Click on OK to make the changes you specified for the column and close the Change Column window.

3. 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

• Data types -- See the SQL Reference
• LOB units -- See the SQL Reference
• Default values -- See the SQL Reference
• Null values -- See the SQL Reference

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]