> For the complete documentation index, see [llms.txt](https://docs.tibero.com/tiberostudio.en/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tibero.com/tiberostudio.en/about/schema-tree-browser/table/create-table.md).

# Create Table

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](#common "mention"), [#columns](#columns "mention"), [#constraints](#constraints "mention"), [#indexes](#indexes "mention"), [#storage](#storage "mention"), [#partition](#partition "mention"), [#comment](#comment "mention") .

<figure><img src="/files/RCrij7Vydvlo2pvHiEWc" alt=""><figcaption><p>Create Table screen</p></figcaption></figure>

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.

<figure><img src="/files/xlgi5y7sAznsDIsRmohg" alt=""><figcaption><p>Create Table - Common tab screen</p></figcaption></figure>

<table><thead><tr><th width="119">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Schema</strong></td><td><p>Select the Schema to create the table.</p><p>Default: Current connection created Schema</p></td></tr><tr><td><strong>Name</strong></td><td>Enter the name of the table to be created.</td></tr><tr><td><strong>Type</strong></td><td><p>Select the type of table to be created.<br></p><ul><li>Normal</li><li>Global Temporary</li><li>Index Organized</li></ul></td></tr></tbody></table>

## Columns

Sets the columns of the table to be created.&#x20;

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

<figure><img src="/files/ImrkoatgOeMe7fIImBLO" alt=""><figcaption><p>Create Table - Columns tab screen</p></figcaption></figure>

**Column List**

<table><thead><tr><th width="86">Button</th><th>Description</th></tr></thead><tbody><tr><td><img src="/files/oP8JsG2FB1bISpbsOQT8" alt=""></td><td>Adds Column.</td></tr><tr><td><img src="/files/j6T6PujcJ1qU80jydVzB" alt=""></td><td>Deletes the currently selected column. </td></tr><tr><td></td><td>Moves the order of the currently selected column up. </td></tr><tr><td></td><td>Moves the order of the currently selected column down. </td></tr><tr><td><img src="/files/3bZxJM4bhijRlZXROxFd" alt=""></td><td>Moves the order of the currently selected column to the top.</td></tr><tr><td><img src="/files/2GoPW4jXNHRUAfr0efiR" alt=""></td><td>Moves the order of the currently selected column to the bottom.</td></tr><tr><td><img src="/files/jCbc0rdyR84J9g5vAiZr" alt=""></td><td>Sets the initial state.</td></tr></tbody></table>

* Column detail settings

  <table><thead><tr><th width="163">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Column Name</strong></td><td>Sets the name of the column.</td></tr><tr><td><strong>Data Type</strong></td><td><p>Sets the data type of the column.<br></p><ul><li>VARCHAR</li><li>VARCHAR2</li><li>CHAR</li><li>NUMBER</li><li>DATE</li><li>CLOB (Cannot be set if Index Organized Type)</li><li>BINARY_DOUBLE</li><li>BINARY_FLOAT</li><li>BLOB (Cannot be set if Index Organized Type)</li><li>INTERVAL DAY TO SECOND</li><li>INTERVAL YEAR TO MONTH</li><li>JSON (Cannot be set if Index Organized Type)</li><li>LONG (Cannot be set if Index Organized Type)</li><li>LONG RAW (Cannot be set if Index Organized Type)</li><li>NCHAR</li><li>NCLOB (Cannot be set if Index Organized Type)</li><li>NVARCHAR</li><li>RAW</li><li>ROWID</li><li>TIME</li><li>TIMESTAMP</li><li>TIMESTAMP WITH LOCAL TIME ZONE</li><li>TIMESTAMP WITH TIME ZONE</li><li>XMLTYPE (Cannot be set if Index Organized Type)<br></li></ul><p>Sets Size, Precision, Scale, etc. for each type.</p></td></tr><tr><td><strong>Not Null</strong></td><td>Sets whether the column is Not Null. </td></tr><tr><td><strong>Default</strong></td><td>Specifies the default value of the column. </td></tr><tr><td><strong>Encryption</strong></td><td><p>Sets the column's encryption and encryption options.</p><p>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. </p></td></tr><tr><td><strong>Comment</strong></td><td>Sets the column's comment. </td></tr></tbody></table>

## Constraints

Sets the constraints of the table.&#x20;
\
Global Temporary Type Table is unavailable to be set constraints.

<figure><img src="/files/qYbVCduXtc7EVaLz38RL" alt=""><figcaption><p>Create Table - Constraints tab screen</p></figcaption></figure>

<table><thead><tr><th width="189">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Costraints Type</strong></td><td><p>Selects the type of constraints.<br></p><ul><li>Primary Key</li><li>Unique Key</li><li>Foreign Key</li><li>Check</li></ul></td></tr><tr><td><strong>Constraints Name</strong></td><td>Enters the name of the constraints.</td></tr><tr><td><strong>Enable</strong></td><td>Selects the activate and inactivate the constraints.</td></tr><tr><td><strong>Validate</strong></td><td>Selects whether the inserted data meets the constraint.</td></tr></tbody></table>

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**

<figure><img src="/files/QUasRGFO1esnfzi3U31c" alt=""><figcaption><p>Create Table - Constraints tab - Primary Key Type selection screen</p></figcaption></figure>

<table><thead><tr><th width="109.12603759765625">Button</th><th>Description</th></tr></thead><tbody><tr><td><img src="/files/oP8JsG2FB1bISpbsOQT8" alt=""></td><td><p>Add the column to be set the constraints.</p><p>Column list set on column tab is shown and added to the list in the order selected.</p></td></tr><tr><td><img src="/files/j6T6PujcJ1qU80jydVzB" alt=""></td><td>Deletes the currently selected column.</td></tr><tr><td></td><td>Moves the order of the currently selected column up. </td></tr><tr><td></td><td>Moves the order of the currently selected column down.</td></tr><tr><td><img src="/files/3bZxJM4bhijRlZXROxFd" alt=""></td><td>Moves the order of the currently selected column to the top. </td></tr><tr><td><img src="/files/2GoPW4jXNHRUAfr0efiR" alt=""></td><td>Moves the order of the currently selected column to the bottom. </td></tr><tr><td><img src="/files/jCbc0rdyR84J9g5vAiZr" alt=""></td><td>Sets the initial state.</td></tr></tbody></table>

**Deferrable State**

<table><thead><tr><th width="211">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Not Deferrable</strong></td><td>Does not specify the Deferrable constraint option by default.</td></tr><tr><td><strong>Initially Deferred</strong></td><td>Selects whether the constraint is checked at the time of commit.</td></tr><tr><td><strong>Initially Immediate</strong></td><td>Selects whether the constraint is checked immediately when the DML statement is run.</td></tr></tbody></table>

**Unique Key**

Same as Primary Key.

**Foreign Key**

<figure><img src="/files/IFvNm8qDK9xOIHf4uwVe" alt=""><figcaption><p>Create Table - Constraints tab - Foreign Key Type select screen</p></figcaption></figure>

<table><thead><tr><th width="204">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Constraint Column</strong></td><td>Selects the column to be referenced, and the list of columns set on the Columns tab is shown.</td></tr><tr><td><strong>Owner</strong></td><td>Selects the owner of the referenced table. </td></tr><tr><td><strong>Table</strong></td><td>Selects the table to be referenced, and the list of table owned by the selected owner is shown.</td></tr><tr><td><strong>Column</strong></td><td>Selects the column of the referenced table, and the column list of  selected table is shown.</td></tr><tr><td><strong>On Delete</strong></td><td><p>Sets the action for the referenced column when the referenced column is deleted.<br></p><ul><li>No Action: By default, no action is set.</li><li>Cascade: When the value of the referenced column is deleted, the value of the referenced column is also deleted.</li><li>Set Null: When the value of the referenced column is deleted, the value of the referenced column is changed to NULL.</li></ul></td></tr></tbody></table>

**Check**

<figure><img src="/files/fuVRgjUyyzuRO51kZ38p" alt=""><figcaption><p>Create Table - Constraints tab - Check Type select screen</p></figcaption></figure>

<table><thead><tr><th width="176">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Check Condition</strong></td><td>Enters the constraint to be set.</td></tr><tr><td><strong>Deferrable State</strong></td><td>References deferrable State of Primary Key <br><a data-mention href="#constraints">#constraints</a></td></tr></tbody></table>

{% hint style="info" %}
**Note**

Foreign keys cannot be set on temporary types.
{% endhint %}

## Indexes

<figure><img src="/files/3uPHWSmS21T1sJT8ZoVb" alt=""><figcaption><p>Create Table - Indexes tab screen</p></figcaption></figure>

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

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.

<table><thead><tr><th width="167">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Index Type</strong></td><td><p>Setects the type of Index<br></p><ul><li>Non-Unique (Default)</li><li>Unique</li><li>Bitmap</li></ul></td></tr><tr><td><strong>Index Name</strong></td><td>Enters the name of Index.</td></tr><tr><td><strong>Column Settings</strong></td><td><p>The area to add the columns to set the index.</p><p>Change the order by dragging and dropping is also available.</p><p></p><ul><li>Column : Selects the column to set Index. The list of column set on column tab is shown.</li><li>Expression : Enters the column name or expression to be used as the Index Key.</li><li>Order : Selects the sort order of the column.</li></ul></td></tr></tbody></table>

## IOT (Index Organized Type)

Sets IOT detailed options for creating an Index Organized Type Table.&#x20;

<figure><img src="/files/BkAjqpxRyPmir89g6UYQ" alt=""><figcaption><p>Create Table - IOT tab screen</p></figcaption></figure>

<table><thead><tr><th width="196">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>PCT Threshold</strong></td><td>Sets the maximum size to be used for Index Block.</td></tr><tr><td><strong>Overflow</strong></td><td>Sets if the user wants to store data separately from the Index Block except for the primary key.</td></tr><tr><td><strong>Including Column</strong></td><td>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.</td></tr></tbody></table>

## Storage

<figure><img src="/files/3511qDjnBdUth4V2UJuc" alt=""><figcaption><p>Create Table - Storage tab</p></figcaption></figure>

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

**Table Compression**

Sets whether to compress the table.

<table><thead><tr><th width="269">Value</th><th>Description</th></tr></thead><tbody><tr><td><strong>No Compression</strong></td><td>Does not compress the table by default.</td></tr><tr><td><strong>Compress</strong></td><td>Compresses table only when using DPI/DPL.</td></tr><tr><td><strong>Compress For All Operations</strong></td><td>Compresses table only when using regular DML.</td></tr><tr><td><strong>Compress For OLTP</strong></td><td>Compresses table only when using regular DML.</td></tr></tbody></table>

**Degreee of Parallelism (DOP)**

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

<table><thead><tr><th width="124">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>None</strong></td><td>Does not use DOP. (NO PARALLEL is set.)</td></tr><tr><td><strong>Default</strong></td><td>Sets PARALLEL </td></tr><tr><td><strong>Set Value</strong></td><td>Applies a user-selected value. When selected, the right input area is activated, and PARALLEL is entered in the area without setting value.</td></tr></tbody></table>

**Segment Settings**

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

<table><thead><tr><th width="145">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Tablespace</strong></td><td>Seletsc Tablespace.<br>The list of tablespace from Database is shown. <br>Default Tablespace is used if default is selected.</td></tr><tr><td><strong>PCT Free</strong></td><td><p>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.</p><p>Sets value between 1 and 99, and the default value is 10.</p></td></tr><tr><td><strong>Initrans</strong></td><td>Sets the number of spaces to be reserved for transaction entry for each disk block. 1 ~ 255, and the default value is 2.</td></tr><tr><td><strong>Logging</strong></td><td><p>Selects whether to leave a redo log when using Direct-Path Loading. </p><p>The default value is Logging.</p></td></tr></tbody></table>

**Storage Option**

Sets the detailed properties of segment.

<table><thead><tr><th width="172">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Max Extents</strong></td><td>Sets the maximum number of extent allocated to the segment. <br>If Unlimited is selected, the number setting area is disabled.</td></tr><tr><td><strong>Buffer Pool</strong></td><td><p>Sets the Buffer Pool to enter the datablock of Segement. <br></p><ul><li>Keep: Puts the blocks of the Segment into the KEEP Buffer Pool to preserve them in memory.</li><li>Recycle: Puts the blocks of the Segment into the RECYCLE Buffer Pool so that the DEFAULT Buffer Pool does not store unnecessary buffer cache.</li><li>Default: If DEFAULT is set or BUFFER_POOL option is not set, the DEFAULT Buffer Pool is used.</li></ul></td></tr></tbody></table>

{% hint style="info" %}
**Note**

Setting Tablespace is only avalable for Temporary Type.
{% endhint %}

## Partition

Sets the partition of table.

<figure><img src="/files/fE6mDpKnAmh2LaCwCyNR" alt=""><figcaption><p>Create Table - Partition tab screen</p></figcaption></figure>

Setting Type and column of Partition and SubPartition are available.

<table><thead><tr><th width="153">Partition</th><th>Can be set Type </th></tr></thead><tbody><tr><td><strong>Partition</strong></td><td><p></p><ul><li>None : No Partition is set by default.</li><li>Range</li><li>Range(Interval)</li><li>List</li><li>Hash</li></ul></td></tr><tr><td><strong>SubPartition</strong></td><td><p></p><ul><li>None :  No SubPartition is set by default.</li><li>Range</li><li>List</li><li>Hash</li></ul></td></tr></tbody></table>

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](#columns "mention")<br>

<figure><img src="/files/fW7WTxDiG3DcO5tiENoK" alt=""><figcaption><p>Create Table - Partition tab - Column setting completion screen</p></figcaption></figure>

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.

<figure><img src="/files/HWulmhuhzWYX5j7pa1d5" alt=""><figcaption><p>Create Table - Partition tab - Screen when set Partition Detail button is clicked</p></figcaption></figure>

For partition List, it runs the same as Column List on Columns tab.  [#columns](#columns "mention")\
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**

<figure><img src="/files/zBAwduf9aTNjEPGDNsTz" alt=""><figcaption><p>Create Table - Partition tab - Screen when set Partition Detail - Range Type </p></figcaption></figure>

<table><thead><tr><th width="184">Field</th><th>Name</th></tr></thead><tbody><tr><td><strong>Partitioin Name</strong></td><td>Enters the name of partition.</td></tr><tr><td><strong>Values less than</strong></td><td><p>Sets the criteria of the value to partition the selected column.</p><ul><li>Column: Name of the column added in the Partition Type setting screen</li><li>Value: Specifies the upper bound value of the partition</li><li>Max Value: If checked, all rows whose value is larger than the previous partition, including NULL values, will be entered into the partition.</li></ul></td></tr><tr><td><strong>Table Compression</strong></td><td><p></p><p>Selects whether to compress or not. </p><p>Storage tab - Refer to the Table Compression <a data-mention href="#storage">#storage</a></p></td></tr><tr><td><strong>Storage Settings</strong></td><td>Sets the storage details. <br>Refer to the Storage tab <a data-mention href="#storage">#storage</a></td></tr></tbody></table>

**Range(Interval) Type**

<figure><img src="/files/FrE4lhk30Y1Fgw8g6lte" alt=""><figcaption><p>Create Table - Partition tab - Screen when set Partition Detail - Range(Interval) Type </p></figcaption></figure>

<table><thead><tr><th width="207">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Interval</strong></td><td>Enters the Interval value of Range Partition.</td></tr><tr><td><strong>Partitioin Name</strong></td><td>Enters the name of partition.</td></tr><tr><td><strong>Values less than</strong></td><td>Sets the Upper bound value of Partition.</td></tr><tr><td><strong>Table Compression</strong></td><td>Selects whether to compress or not. <br>Storage tab - Refer to the Table Compression  <a data-mention href="#storage">#storage</a></td></tr><tr><td><strong>Storage Settings</strong></td><td>Sets the storage details.<br>Refer to the storage tab <a data-mention href="#storage">#storage</a></td></tr></tbody></table>

**List Type**

<figure><img src="/files/nbFl8NGYpcDpJbYmSJck" alt=""><figcaption><p>Create Table - Partition tab - Screen when set Partition Detail - List Type </p></figcaption></figure>

**Hash Type**

* Hash

  <figure><img src="/files/GghkaibD2e6NCydb7PcP" alt=""><figcaption><p>Create Table - Partition tab -Screen when set Partition Detail - Hash Type </p></figcaption></figure>

  <table><thead><tr><th width="198">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Partitioin Name</strong></td><td>Enters the name of the partition.</td></tr><tr><td><strong>Table Compression</strong></td><td>Selects whether to compress or not. <br>Storage tab - Refer to the Table Compression <a data-mention href="#storage">#storage</a></td></tr><tr><td><strong>Storage Settings</strong></td><td>Sets Tablespace.<br>Refer to the storage tab <a data-mention href="#storage">#storage</a></td></tr></tbody></table>

* Hash By Quantity

  <figure><img src="/files/ovXuqU45iQRvWo9M4bBL" alt=""><figcaption><p>Create Table - Partition tab - Screen when set Partition Detail - Hash By Quantity Type </p></figcaption></figure>

  <table><thead><tr><th width="200">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Hash Quantity</strong></td><td>Sets the number of partition.</td></tr><tr><td><strong>Select Tablespace</strong></td><td><p>Sets tablespace.</p><p>User can add from the list of tablespaces in the database.</p><p>The working of List is the same as Column List on the Constraints tab. <a data-mention href="#constraints">#constraints</a></p></td></tr></tbody></table>

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

<figure><img src="/files/4fUkiLOExAeZIpyHd625" alt=""><figcaption><p>Create Table - Partition tab - SubPartition Template screen</p></figcaption></figure>

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

## Comment

<figure><img src="/files/rG8DAZbgmDdf1fKoeIHq" alt=""><figcaption><p>Create Table - Comment tab screen</p></figcaption></figure>

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.

###


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.tibero.com/tiberostudio.en/about/schema-tree-browser/table/create-table.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.