Editing column lists when altering a table

Use the Edit Column Lists window of the Alter Table notebook to change the default values for the columns in the predefined column lists.

Fields and controls



To change the default values of predefined columns:

  1. Open the Edit Column Lists window of the Alter Table notebook.

  2. To change a list name:

    1. In the List name box, select a column list whose name you want to change.

    2. In the List name field, type a new name for the column list.

    3. Click on the Change push button next to the List name box.

  3. Change the default values of a column:

    1. In the Columns box, select a column whose default values you want to change.

    2. Click on Change. The Change Column window opens. 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.

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

  4. Click on OK to save the changes that you specified for the predefined column and close the Edit Column Lists window.


Related information