Changing existing columns when altering a table

Use the Columns page of the Alter Table notebook to change the comment for existing columns in your table or to change the length of an existing VARCHAR column.

Fields and controls

Authorities and privileges



To change the comment for an existing column:

  1. Open the Alter Table notebook.

  2. Click on the Columns tab.

  3. In the Columns box, select the column that you want to change.

  4. Click on Change. The Change Column window opens.

  5. In the Comment field, type a new comment for the column or edit the existing comment.

  6. Optional: If you selected a VARCHAR column, you can change the column length. In the Length field, type a new length for the column.

    Attention: The new column length must be greater than the current column length.

  7. Click on OK to make the changed you specified and close the Change Column window.

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