Using the Schema Editor

Both the CREATE TABLE and ALTER TABLE menus have the same options, which are described in the following list.

Option	Purpose	Instructions
Add	Displays the Schema Editor, from which you can add a new column to the table	Adding Columns to a Table (Add Option)
Modify	Displays the columns that you defined with the Add option so that you can modify the column structure before building the table	Modifying Columns (Modify Option)
Drop	Drops an existing column from the table	Deleting Columns (Drop Option)
Screen	Displays the next screen of column definitions in the Schema Editor	none
Table_options	Displays and enables you to select storage spaces for a new table Displays choices from which you set a fragmentation strategy for a new table Enables you to set extent sizes and lock mode for a new table Adds or deletes rowids for an existing fragmented table	Arranging Storage and Locking (Table_options)
Constraints	Enables you to define primary-key, foreign-key, check, and unique constraints Enables you to set default column values	Defining Constraints Defining Default Values
Exit	Builds, rebuilds, or discards the schema and structure that you described with the other options and then returns to the TABLE menu	Building the Table (Exit Option)

Important:

You must use the SPACEBAR to move between menu options because the arrow keys control cursor movement in the Schema Editor.

To leave the CREATE TABLE menu or ALTER TABLE menu and return to the TABLE menu without building or altering a table, press the Interrupt key.