Create Table SmartGuide -- Fields and controls

Name page
Columns page
Edit Columns page
Primary Key page
Table Space page
Figure pbullet not displayed. Back
Figure pbullet not displayed. Next
Figure pbullet not displayed. Done
Figure pbullet not displayed. Show SQL
Figure pbullet not displayed. Cancel



Name page

Figure pbullet not displayed. Table schema
Figure pbullet not displayed. Table name

Figure pbullet not displayed. 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:

Figure pbullet not displayed. 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

Figure pbullet not displayed. Column lists
Figure pbullet not displayed. Available columns
Figure pbullet not displayed. >, >>, <, <<
Figure pbullet not displayed. Columns to create
Figure pbullet not displayed. Edit Lists
Figure pbullet not displayed. Column name

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. >, >>, <, <<

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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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

Figure pbullet not displayed. Columns
Figure pbullet not displayed. Add
Figure pbullet not displayed. Change
Figure pbullet not displayed. Remove
Figure pbullet not displayed. Up
Figure pbullet not displayed. Down

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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.

Figure pbullet not displayed. Remove

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

Figure pbullet not displayed. Up

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

Figure pbullet not displayed. Down

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



Primary Key page

Figure pbullet not displayed. Available columns
Figure pbullet not displayed. >, >>, <, <<
Figure pbullet not displayed. Primary key columns

Figure pbullet not displayed. 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.

Figure pbullet not displayed. >, >>, <, <<

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.

Figure pbullet not displayed. 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

Figure pbullet not displayed. Table space
Figure pbullet not displayed. Separate index space
Figure pbullet not displayed. Separate long space
Figure pbullet not displayed. Create

Figure pbullet not displayed. 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.

Figure pbullet not displayed. 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:

Figure pbullet not displayed. 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:

Figure pbullet not displayed. 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.