Specifies the schema to which the table belongs. The initial value is the user ID under which you connected to the database. You can either select another schema or create one using the Create Schema window.
Type a name for the table that you are creating. This name can be 1 - 128 characters.
Attention: This name must be unique within the table's schema. No other object in the schema can have the same name as the table.
Lists all of the categories of predefined columns. Select a column category from which you want to choose one or more predefined columns to add to your table.
Lists all of the predefined columns in the category that you selected in the Column categories list. Select the predefined column or columns that you want to add to your table. You can select one or more predefined columns at the same time.
Copies the selected column in the Predefined columns list to the Columns to create list.
Copies all columns displayed in the Predefined columns list to the Columns to create list.
Removes the selected column from the Columns to create list.
Removes all columns from the Columns to create list.
Lists all of the predefined columns to add to your table. To add a predefined column to this list, select it in the Predefined columns list and click the > push button.
Opens the Change Column Categories window so that you can add, change, or remove a column category. In that window you can also add, change, or remove a column from a column category.
Optional: Contains the name of the column selected in the Columns to create list. To change the column name, type a new name or edit the existing name. This name can be 1 - 30 characters long.
Attention: You cannot use the same name for more than one column of the table.
Lists of all of the columns defined for the table that you are creating. Use this list to view your column definitions or to select a column that you want to change, remove, or reorder. You can select a new column to change any field, remove the new column from the table, or reorder the new column among the other new columns. Click Add to add a column to this list.
Opens the Add Column window so that you can add a new column to the table that you are creating.
See the SQL Reference for limits on the maximum number of columns that you can create.
Opens the Change Column window so that you can change an attribute of the column that is selected in the Columns list.
Removes the selected column from the Columns list.
Moves the selected column in the Columns list up one position.
Moves the selected column in the Columns list down one position.
Lists all of the columns defined for the table that are not currently defined as primary key columns. Use this list to select the column or columns that you want to define as primary key columns and then click the > push button. You can select one or more columns at the same time.
You can define 1 - 16 columns to be primary key columns. The sum of their length attributes must not exceed 255 bytes.
Attention: You cannot define columns of data type LOB, LONG VARCHAR, or LONG VARGRAPHIC to be primary key columns.
Moves the selected columns in the Available columns list to the Primary key columns list.
Moves all columns displayed in the Available columns list to the Primary key columns list.
Moves the selected columns in the Primary key columns list to the Available columns list.
Moves all columns displayed in the Primary key columns list to the Available columns list.
Lists all of the columns defined as primary key columns. The order of the columns in this list is significant because the database manager uses the primary key for efficient access to table data.
Use this list to view the primary key columns or to select a column or columns to remove from the list with the < push button.
To add a column to this list, select a column from the Available columns list and then click the > push button.
Specifies the table space in which to create the table.
Select a DMS table space if you want to specify a separate index space or a separate long space.
For information about default table spaces, see the Create Table section in the SQL Reference.
Specifies a separate index space to be used for indexes. This option is only available when you have specified to use a DMS table space.
Specifies a separate index space in which to store indexes.
This option is only available when you have specified to use a DMS table space.
Select an index space from the drop-down list.
Specifies that a separate long space is to be used in which to store the values of any long columns. Long data can be LONG VARCHAR, LONG VARGRAPHIC, LOB data types, or a distinct type with any of these as source types.
This option is only available when you have specified to use a DMS table space. If you do not specify a separate long space, the long data will be stored in the same table space as the table.
Specifies a separate long space in which to store the values of any long columns. Long data can be LONG VARCHAR, LONG VARGRAPHIC, LOB data types, or a distinct type with any of these as source types.
This option is only available when you check the Use separate long space check box. If you do not specify a separate long space, the long data will be stored in the same table space as the table.
Select a long space from the drop-down list.
Opens the Create Table Space wizard so that you can create a new table space. The default value for data type is REGULAR. For management, you can select SMS or DMS. These values will be specified in the Create Table Space wizard.
Opens the Create Table Space wizard so that you can create a new index space. The default value for data type is REGULAR and the default value for management is DMS, which will be specified in the Create Table Space wizard.
This push button is available only if you specified an index space other than <default> in the field below the Use separate index space check box.
Opens the Create Table Space wizard so that you can create a new long space. The default value for data type is LONG and the default value for management is DMS, which will be specified in the Create Table Space wizard.
This push button is available only if you specified a long space other than <default> in the field below the Use separate long space check box.