The owner of this table. You cannot change this value when you alter a table.
Opens a List window that you can use to view or filter the available items and select one. 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.
Opens a List window that you can use to view or filter the available items and select one. You cannot change this value when you alter a table.
The tables edit routine. You cannot change this value when you alter a table.
The name of this table. You cannot change this value when you alter a table.
Optional: Type the name of the program to be used for the tables 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.
Select the type of table access that will cause auditing to be performed:
Select an encoding scheme for the tables 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 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 a column that you want to change, remove, or reorder. To add a column to this table, click the Add push button. To change, remove, or reorder a column, select it and then click the Change, Remove, Up, or Down push buttons.
Opens a window so that you can add a new column to the list.
Opens a window so that you can change an attribute of the selected column. Available only if a column is selected.
Removes the selected column from the column list. Available only if a column is selected.
Moves the selected column up one position. Available only if a column is selected.
Moves the selected column down one position. Available only if a column 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 the > push button. 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 can view the unique key definitions and select a unique key that you want to change or remove before committing your choices in the Create Table notebook. To add a unique key, click the Add push button. To change or remove a unique key, select it and then click the Change or Remove push buttons.
Opens a window so that you can add a new unique key.
Opens a window so that you can change the selected key. Available only if a unique key is selected.
Removes the selected key from the unique key columns list. Available only if a unique key is selected.
Shows all of the foreign keys defined for the table. To add a new key, click the Add push button. To change or remove a foreign key, select it and then click the Change or Remove push buttons.
Opens a window so that you can add a new foreign key.
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 list. 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 the Add push button. To change or remove a check constraint, select it and then click the Change or Remove push buttons.
Opens a window so that you can add a new check constraint.
Opens a window so that you can change the selected check constraint. Available only if a constraint is selected.
Removes the selected check constraint from the check constraints list. Available only if a constraint is selected.
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 and closes the notebook or window.