Docs Home

Create Table

It describes how to create the table objects with Gui Operation.

Table object can be created through the GUI operation as executing the following process.

Table Folder > Context Menu > Create Table

The details can be set in each tab Common, Columns, Constraints, Indexes, Storage, Partition, Comment .

Create Table screen

SQL applied to the settings is shown in the SQL area at the bottom.

Common

Sets the Schema, Name, and Type of the table to be created.

Create Table - Common tab screen
Field
Description

Schema

Select the Schema to create the table.

Default: Current connection created Schema

Name

Enter the name of the table to be created.

Type

Select the type of table to be created.

  • Normal

  • Global Temporary

  • Index Organized

Columns

Sets the columns of the table to be created.

Adds and selects columns from the list on the left to set the details of each column.

Create Table - Columns tab screen

Column List

Button
Description

Adds Column.

Deletes the currently selected column.

Moves the order of the currently selected column up.

Moves the order of the currently selected column down.

Moves the order of the currently selected column to the top.

Moves the order of the currently selected column to the bottom.

Sets the initial state.

  • Column detail settings

    Field
    Description

    Column Name

    Sets the name of the column.

    Data Type

    Sets the data type of the column.

    • VARCHAR

    • VARCHAR2

    • CHAR

    • NUMBER

    • DATE

    • CLOB (Cannot be set if Index Organized Type)

    • BINARY_DOUBLE

    • BINARY_FLOAT

    • BLOB (Cannot be set if Index Organized Type)

    • INTERVAL DAY TO SECOND

    • INTERVAL YEAR TO MONTH

    • JSON (Cannot be set if Index Organized Type)

    • LONG (Cannot be set if Index Organized Type)

    • LONG RAW (Cannot be set if Index Organized Type)

    • NCHAR

    • NCLOB (Cannot be set if Index Organized Type)

    • NVARCHAR

    • RAW

    • ROWID

    • TIME

    • TIMESTAMP

    • TIMESTAMP WITH LOCAL TIME ZONE

    • TIMESTAMP WITH TIME ZONE

    • XMLTYPE (Cannot be set if Index Organized Type)

    Sets Size, Precision, Scale, etc. for each type.

    Not Null

    Sets whether the column is Not Null.

    Default

    Specifies the default value of the column.

    Encryption

    Sets the column's encryption and encryption options.

    Encryption option is the same as the encryption algorithm supported by Tibero, can specify whether to use the SALT function to enhance security. This item is disabled for CLOB, BLOB, LONG, NCLOB, and ROWID types.

    Comment

    Sets the column's comment.

Constraints

Sets the constraints of the table. Global Temporary Type Table is unavailable to be set constraints.

Create Table - Constraints tab screen

Field
Description

Costraints Type

Selects the type of constraints.

  • Primary Key

  • Unique Key

  • Foreign Key

  • Check

Constraints Name

Enters the name of the constraints.

Enable

Selects the activate and inactivate the constraints.

Validate

Selects whether the inserted data meets the constraint.

Set the details in the bottom area according to the type selected in the top Constraints Info.

The following describes the settings for each type of Key.

Primary Key

Create Table - Constraints tab - Primary Key Type selection screen
Button
Description

Add the column to be set the constraints.

Column list set on column tab is shown and added to the list in the order selected.

Deletes the currently selected column.

Moves the order of the currently selected column up.

Moves the order of the currently selected column down.

Moves the order of the currently selected column to the top.

Moves the order of the currently selected column to the bottom.

Sets the initial state.

Deferrable State

Field
Description

Not Deferrable

Does not specify the Deferrable constraint option by default.

Initially Deferred

Selects whether the constraint is checked at the time of commit.

Initially Immediate

Selects whether the constraint is checked immediately when the DML statement is run.

Unique Key

Same as Primary Key.

Foreign Key

Create Table - Constraints tab - Foreign Key Type select screen
Field
Description

Constraint Column

Selects the column to be referenced, and the list of columns set on the Columns tab is shown.

Owner

Selects the owner of the referenced table.

Table

Selects the table to be referenced, and the list of table owned by the selected owner is shown.

Column

Selects the column of the referenced table, and the column list of selected table is shown.

On Delete

Sets the action for the referenced column when the referenced column is deleted.

  • No Action: By default, no action is set.

  • Cascade: When the value of the referenced column is deleted, the value of the referenced column is also deleted.

  • Set Null: When the value of the referenced column is deleted, the value of the referenced column is changed to NULL.

Check

Create Table - Constraints tab - Check Type select screen
Field
Description

Check Condition

Enters the constraint to be set.

Deferrable State

References deferrable State of Primary Key Constraints

Note

Foreign keys cannot be set on temporary types.

Indexes

Create Table - Indexes tab screen

Sets the indexes of the table to be created. Indexes created by constraints on the Constraints tab cannot be modified.

The Index List on the left runs the same as the Column List on the Columns tab. #columns

Selects from the Index List on the left to set details for each index.

Field
Description

Index Type

Setects the type of Index

  • Non-Unique (Default)

  • Unique

  • Bitmap

Index Name

Enters the name of Index.

Column Settings

The area to add the columns to set the index.

Change the order by dragging and dropping is also available.

  • Column : Selects the column to set Index. The list of column set on column tab is shown.

  • Expression : Enters the column name or expression to be used as the Index Key.

  • Order : Selects the sort order of the column.

IOT (Index Organized Type)

Sets IOT detailed options for creating an Index Organized Type Table.

Create Table - IOT tab screen
Field
Description

PCT Threshold

Sets the maximum size to be used for Index Block.

Overflow

Sets if the user wants to store data separately from the Index Block except for the primary key.

Including Column

Selects a column that can be stored with the primary key in the Index Block. ColumnsList of columns set on the Columns tab is shown.

Storage

Create Table - Storage tab

Sets the physical properties of the storage space and detailed properties of Tablespace and Segment. Initial state can be set by clicking the [Reset button] at the bottom right.

Table Compression

Sets whether to compress the table.

Value
Description

No Compression

Does not compress the table by default.

Compress

Compresses table only when using DPI/DPL.

Compress For All Operations

Compresses table only when using regular DML.

Compress For OLTP

Compresses table only when using regular DML.

Degreee of Parallelism (DOP)

Sets the number of working threads (WTHR) that perform one operation together.

Field
Description

None

Does not use DOP. (NO PARALLEL is set.)

Default

Sets PARALLEL

Set Value

Applies a user-selected value. When selected, the right input area is activated, and PARALLEL is entered in the area without setting value.

Segment Settings

Specifies the physical properties of the storage space and the Tablespace.

Field
Description

Tablespace

Seletsc Tablespace. The list of tablespace from Database is shown. Default Tablespace is used if default is selected.

PCT Free

When saving data to a disk block, sets the area to be left as a reserve in case the size increases due to data changes.

Sets value between 1 and 99, and the default value is 10.

Initrans

Sets the number of spaces to be reserved for transaction entry for each disk block. 1 ~ 255, and the default value is 2.

Logging

Selects whether to leave a redo log when using Direct-Path Loading.

The default value is Logging.

Storage Option

Sets the detailed properties of segment.

Field
Description

Max Extents

Sets the maximum number of extent allocated to the segment. If Unlimited is selected, the number setting area is disabled.

Buffer Pool

Sets the Buffer Pool to enter the datablock of Segement.

  • Keep: Puts the blocks of the Segment into the KEEP Buffer Pool to preserve them in memory.

  • Recycle: Puts the blocks of the Segment into the RECYCLE Buffer Pool so that the DEFAULT Buffer Pool does not store unnecessary buffer cache.

  • Default: If DEFAULT is set or BUFFER_POOL option is not set, the DEFAULT Buffer Pool is used.

Note

Setting Tablespace is only avalable for Temporary Type.

Partition

Sets the partition of table.

Create Table - Partition tab screen

Setting Type and column of Partition and SubPartition are available.

Partition
Can be set Type

Partition

  • None : No Partition is set by default.

  • Range

  • Range(Interval)

  • List

  • Hash

SubPartition

  • None : No SubPartition is set by default.

  • Range

  • List

  • Hash

Setting column in the bottom area is available If the Type of Partition and SubPartition are selected.

For Column list, it runs the same as Column List on Columns tab. Columns

Create Table - Partition tab - Column setting completion screen

When the column settings are completed in the bottom area, the [Set Partition Detail button] at the bottom right corner is activated. Click the [Set Partition Detail button] to set the details.

Create Table - Partition tab - Screen when set Partition Detail button is clicked

For partition List, it runs the same as Column List on Columns tab. Columns Click the [Set Partition Detail button] to set the details.

User can check the current partition type and subpartition type at the top, and click the [Change Partition Type button] to return to the previous screen and change the partition type.

Below are the detailed settings for each Partition Type.

Range Type

Create Table - Partition tab - Screen when set Partition Detail - Range Type
Field
Name

Partitioin Name

Enters the name of partition.

Values less than

Sets the criteria of the value to partition the selected column.

  • Column: Name of the column added in the Partition Type setting screen

  • Value: Specifies the upper bound value of the partition

  • Max Value: If checked, all rows whose value is larger than the previous partition, including NULL values, will be entered into the partition.

Table Compression

Selects whether to compress or not.

Storage tab - Refer to the Table Compression Storage

Storage Settings

Sets the storage details. Refer to the Storage tab Storage

Range(Interval) Type

Create Table - Partition tab - Screen when set Partition Detail - Range(Interval) Type
Field
Description

Interval

Enters the Interval value of Range Partition.

Partitioin Name

Enters the name of partition.

Values less than

Sets the Upper bound value of Partition.

Table Compression

Selects whether to compress or not. Storage tab - Refer to the Table Compression Storage

Storage Settings

Sets the storage details. Refer to the storage tab Storage

List Type

Create Table - Partition tab - Screen when set Partition Detail - List Type

Hash Type

  • Hash

    Create Table - Partition tab -Screen when set Partition Detail - Hash Type
    Field
    Description

    Partitioin Name

    Enters the name of the partition.

    Table Compression

    Selects whether to compress or not. Storage tab - Refer to the Table Compression Storage

    Storage Settings

    Sets Tablespace. Refer to the storage tab Storage

  • Hash By Quantity

    Create Table - Partition tab - Screen when set Partition Detail - Hash By Quantity Type
    Field
    Description

    Hash Quantity

    Sets the number of partition.

    Select Tablespace

    Sets tablespace.

    User can add from the list of tablespaces in the database.

    The working of List is the same as Column List on the Constraints tab. Constraints

Finish setting the details of the partition to set the details of the subpartition by checking [Subpartition Template] at the bottom.

Create Table - Partition tab - SubPartition Template screen

SubPartition's detailed item settings by Type are the same as the detailed items by Partition Type.

Comment

Create Table - Comment tab screen

Create a comment for the table. Click [Reset button] to reset the contents.

After setting the details of each tab, click [Create button] to create a Table object with the contents set.

PreviousTableNextEdit Table

Last updated