Submits the data in the notebook and closes the notebook. Available only when the required fields are completed.

Displays the SQL statements that are generated by your choices in this notebook.

Cancels any unsaved changes that you made and closes this notebook.

The owner of this table. You cannot change this value when you alter a table.

The table's edit routine. You cannot change this value when you alter a table.

Select the type of table access that will cause auditing to be performed:

The name of this table. You cannot change this value when you alter a table.

The name of the table space that contains this table. You cannot change this value when you alter a table.

Optional: Type the name of the program to be used for the table's validation exit routine. On inserts, loads, updates, or deletes, it examines the table row and returns a value that indicates whether the operation can proceed. Typical uses are to impose limits on the information that can be entered; for example, allowable salary ranges.

If you replace an existing program name, the new program is not used to validate existing table rows.

Clear this field to discontinue the use of the existing program. Do not type NULL.

The encoding scheme for the table's string data:

You cannot change this value when you alter a table.

Indicates this table has a DB2-generated object identifier (OBID) for this table. You cannot change this value when you alter a table.

Indicates that a specific object identifier (OBID) is used for this table. You cannot change this value when you alter a table.

The object identifier used for this table. You cannot change this value when you alter a table.

Select to prevent the table from being dropped. If selected, the table and the database and table space that contain the table cannot be dropped.

Select if you plan to use this table for replication.

Optional: Type a 1- to 254-character (including embedded blanks) comment to document the table.

Shows the columns defined for the table. You can view the column definitions or select an existing table column for which you want to change the comment. To add a column to this table, click Add. To change a column's comment, select it and then click Change.

Opens a window so that you can add a new column to the table.

Opens a window so that you can change an attribute of the selected column. You can change all attributes for columns that have not been committed yet. However, for existing (committed) columns, you can change only the comment. Available only if a column is selected.

Removes the selected column from the column box. You can remove columns that have not been committed yet. However, you cannot remove existing (committed) columns.

Moves the selected column up one position. Available only if a column that you added while in the Alter Table notebook is selected.

Moves the selected column down one position. Available only if a column that you added while in the Alter Table notebook is selected.

Shows all of the non-nullable columns defined for the table that are not currently defined as primary key columns. Select the column or columns that you want to define as primary key columns and then click >. You can define up to 64 columns to be primary key columns, and the sum of their lengths must not exceed 254.

Moves the selected column in the Available columns box to the Primary key columns box. Available only if a column in the Available columns box is selected.

Moves all columns displayed in the Available columns box to the Primary key columns box. Available only if the Available columns box contains columns.

Moves the selected column in the Primary key columns box to the Available columns box. Available only if a column in the Primary key columns box is selected.

Moves all columns displayed in the Primary key columns box to the Available columns box. Available only if the Primary key columns box contains columns.

Shows all of the columns defined as primary key columns. The order in this list is significant because DB2 uses the primary key for efficient access to table data. To change the order of a column in this list, select the column and click one of the push buttons.

Moves the selected primary key column up one position. Available only if a column in the Primary key columns box is selected.

Moves the selected primary key column down one position in the list. Available only if a column in the Primary key columns box is selected.

Shows all of the unique keys defined for the table. You cannot add, change, or remove unique keys when you alter a table. Use the Create, Alter, or Drop actions on the index instead.

You cannot add unique keys when you alter a table. Use the Create action on the index instead.

You cannot change unique keys when you alter a table. Use the Alter action on the index instead.

You cannot remove unique keys when you alter a table. Use the Drop action on the index instead.

Shows all of the foreign keys defined for the table. To add a new key, click Add. To change or remove a foreign key, select it and then click Change or Remove.

Opens a window so that you can add a new foreign key. If the table is populated, the table space containing the table is placed in check pending status. To clear the check pending status, you need to perform Check data on the table space.

Opens a window so that you can change the selected key. Available if a key is selected.

Removes the selected key from the foreign key box. Available only if a foreign key is selected.

Shows the check constraints for the table. A check constraint sets restrictions on data added to the table. To add a new check constraint, click Add. To change or remove a check constraint, select it and then click Change or Remove.

Opens a window so that you can add a new check constraint. For new constraints, if the table has data, and the CURRENT RULES special register is set to 'DB2', the table space containing the table is placed in check pending state. If CURRENT RULES is 'STD', the table rows are checked against the new constraint, and if any rows violate the constraint, an error occurs and the check is not added.

Opens a window so that you can change the selected check constraint. Available if a constraint is selected.

Removes the selected check constraint from the check constraints box. Available only if a constraint is selected.