<< Click to Display Table of Contents >>

Create Table

Top Previous Next

This dialog lets you create a new table. The upper section asks for the following information:

Table name to be created.

Index name for the primary key. Hora suggests the table name with the suffix _PK.

Type of table

Not temporary

Global temporary table, on commit preserve rows

Global temporary table, on commit delete rows

Below this section is a grid with three tabs. The grid opens with the columns tab selected. This lets you describe the table's columns.

P. Key contains a check box to indicate that the column is part of the primary key. By default, the first column is named ID, and is designated as a primary key column. You can rename the column and/or uncheck the box.

Column name.

Data type. Various values can be selected from a combo box.

Data length of a (var)char or number column. For character fields, you may now specify CHAR or BYTE along with the length to override the length semantics of the database.

Not null.

Default value for the column

Nested table name

Is nested table. This defaults to N, unless you enter a nested table name in the previous column.

For the current column, you can enter column comments in the next part of the window. While entering columns, you can also select one of the tabs at the bottom.

Insert column inserts a new column before the current position.

Append column inserts a new column after the current position.

Delete column removes the column currently being defined.

Add stamps adds 4 columns which can be used to store the name of the user creating or modifying a row, or the date when a row was created or modified.

The second tab, Table Comment, lets you enter a comment applicable to the entire table.

The third tab, Table Storage/Partitioning, allows entry of the following:

Tablespace name for the table. Defaults to the user's default tablespace.

Percent free, i.e. the portion of the block to be kept free for updates to existing rows.

Tablespace name for the primary key index. Defaults to the user's default tablespace.

Index-organized. Check the box to create an index-organized table.

Partition by, sub-partition by. Use these columns to indicate partitioning by range or by hash. To the right, enter the column to be used in range- or hash-partitioning.

 

Press OK to start the operation. The Cancel button closes the dialog without any action.