Create Table SmartGuide -- Fields and controls

Name page
Columns page
Edit Columns page
Primary Key page
Table Space page
" " Back
" " Next
" " Done
" " Show SQL
" " Cancel



Name page

" " Table schema
" " Table name

" " Table schema

Use this box to specify the schema of the table that you're creating. The initial value in this box is the user ID under which you connected to the database. To specify a schema with a name that's different than this ID, use one of these methods:

" " Table name

Type a name for the table that you're creating. This name:

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.



Columns page

" " Column lists
" " Available columns
" " >, >>, <, <<
" " Columns to create
" " Edit Lists
" " Column name

" " Column lists

This box lists all of the categories of predefined columns. Use this box to select a column category from which you want to choose a predefined column to add to your table.

" " Available columns

This box lists all of the predefined columns in the category that you selected in the Column lists box. Use this box to 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.

" " >, >>, <, <<

Use these push buttons to change the list of columns displayed in the Columns to create box. You can use:

>
To copy the selected column in the Available columns box to the Columns to create box.

>>
To copy all columns displayed in the Available columns box to the Columns to create box.

<
To remove the selected column from the Columns to create box.

<<
To remove all columns from the Columns to create box.

" " Columns to create

This box lists all of the predefined columns to add to your table. To add a predefined column to this box, select it in the Available columns box and click on the > push button.

" " Edit Lists

Click on this push button to open the Edit Column Lists window so that you can add a new column list; change a column list name; delete a column list; and add, change, or remove a column from a column list.

" " Column name

Optional: This field contains the name of the column selected in the Columns to create box. To change the column name, type a new name or edit the existing name. This name:

Attention: You cannot use the same name for more than one column of the table.



Edit Columns page

" " Columns
" " Add
" " Change
" " Remove
" " Up
" " Down

" " Columns

This box contains a list of all of the columns defined for the table that you're creating. Use this box 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 on Add to add a column to this list.

" " Add

Click on this push button to open the Add Column window so you can add a new column to the table that you're creating.

You can add up to 500 columns to your table. The sum of the byte counts of the columns must not be greater than 4005.

" " Change

Click on this push button to open the Change Column window so that you can change an attribute of the column that is selected in the Columns box.

" " Remove

Click on this push button to remove from the box the column that is selected in the Columns box.

" " Up

Click on this push button to move the column that is selected in the Columns box up one position.

" " Down

Click on this push button to move the column that is selected in the Columns box down one position.



Primary Key page

" " Available columns
" " >, >>, <, <<
" " Primary key columns

" " Available columns

This box lists all of the columns defined for the table that are not currently defined as primary key columns. Use this box to select the column or columns that you want to define as primary key columns and then click on the > push button. You can select one or more columns at the same time.

You can define up to 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.

" " >, >>, <, <<

Use these push buttons to change the list of columns displayed in the Available columns and Primary key columns boxes. You can use:

>
To move the selected columns in the Available columns box to the Primary key columns box.

>>
To move all columns displayed in the Available columns box to the Primary key columns box.

<
To move the selected columns in the Primary key columns box to the Available columns box.

<<
To move all columns displayed in the Primary key columns box to the Available columns box.

" " Primary key columns

This box 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 box to view the list of 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 box and then click on the > push button.



Table Space page

" " Table space
" " Separate index space
" " Separate long space
" " Create

" " Table space

Optional: Use this box to specify the table space in which to create the table. Use one of these methods:

If you do not specify a table space, either:

You must specify a REGULAR DMS table space other than the default table space if you plan to specify a separate index space or separate long space.

" " Separate index space

Optional: Select this check box to specify a table space in which to create any indexes on the table. Indexes can be stored in a different table space than the table itself. A separate index table space can improve performance for very large tables.

If you select this check box, specify the table space that you want by selecting a REGULAR DMS table space from the dropdown list, or typing the name of an existing REGULAR DMS table space.

If no REGULAR DMS table spaces exist in the database, you can use the Create push button to create one.

If you do not specify a separate index space, the indexes will be created in the same table space as the table.

This check box and box are available only if both:

" " Separate long space

Optional: Select this check box to specify a table 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.

If you select this check box, specify the table space that you want by selecting an existing LONG DMS table space from the dropdown list, or typing the name of an existing LONG DMS table space.

If no LONG DMS table spaces exist in the database, you can use the Create push button to create one.

If you do not specify a separate long space, the long data will be stored in the same table space as the table.

This check box and box are available only if both:

" " Create

Click on this push button to open the Create Table Space SmartGuide so that you can create a new table space. Depending on which Create button you choose, appropriate default values for data type and management will be specified in the Table Space SmartGuide. For table space, the values are REGULAR and SMS. For index space, the values are REGULAR and DMS. For long space, the values are LONG and DMS.

This push button is available for separate index spaces and separate long spaces only if you specified a table space other than the default in the Table space box.