Changing a column

Use the Change Column notebook to modify a column for the table that you're creating or altering. These steps are part of the larger tasks of creating a table and altering a table. When you complete these steps, return to either creating a table or altering a table.

To change a column:

1. In the Change Column notebook, change the fields and controls that you want to modify.

   If you change the column name and you are using this column in a primary key, a unique key, or a foreign key, you must go back and revise the definitions for those keys.

   Restriction: If you are changing a column that has already been committed in the table, the only field that you can modify is the Comment field. The comment can be from 1 to 254 characters long.

2. Click OK to make the change you specified for the column comment and close the Change Column notebook.

Depending on the task that you were doing when you changed this column, return to either creating a table or altering a table.