Modifying Columns (Modify Option)

To modify an existing column, perform the following steps:

1. Use the arrow keys to highlight the column definition that you want to modify.
2. If necessary, select Screen from the CREATE TABLE menu to display the next screen of column definitions in the Schema Editor.
3. Select the Modify option on the CREATE TABLE (or ALTER TABLE) menu and press RETURN.
4. Move the highlight to the field you want to modify.

   DB–Access prompts appropriately for the field where the highlight is located. Each of these prompt screens works like the corresponding ADD screen.

   For instructions on specific prompts, see the following table.

   Prompt

   Instructions

   MODIFY COLUMN NAME

   Column Name

   MODIFY TYPE

   Column Data Type

   MODIFY LENGTH

   Data Length or Range

   MODIFY INDEX

   Column Index

   MODIFY NULLS

   Null Value Permission

5. Move the highlight to the next field and repeat the process.
6. Select Exit to leave the screen after you have elected to build the table or discard the schema, as Figure 53 shows.

To leave a Modify screen or menu without making any changes, press the Interrupt key at any time.