Edit Table

It describes how to modify a Table object using GUI operations.

Execute Table > Context Menu > Edit Table, and the user can edit the Table object through Gui Operation to modify the Table object.

The details can be set in each tab.

Common, Columns, Constraints, Indexes, Storage, Comment

Edit Table screen

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

Common

Checks the Schema, Name, and Type of the table to be modified, and only the Name field can be modified.

Edit Table - Common tab screen

Columns

Checks and modifies the existing column information of the table to be modified.

The detailed operation is the same as Create Table > Columns tab. Columns

Edit Table - Columns tab screen

Constraints

Checks and modifies the existing Constraints information of the table to be modified.

For existing constraints, only Name, Enable, and Visible fields can be modified.

The detailed operation is the same as Create Table > Constraints tab. Constraints

Edit Table - Constraints tab screen

Indexes

Checks and modifies the existing index information of the table to be modified.

For an existing index, only the Name field can be modified.

The detailed operation is the same as Create Table > Indexes tab. Indexes

Edit Table - Indexes tab screen

Storage

Checks and modifies the existing storage information of the table to be edited.

The Max Extents field cannot be modified.

The detailed operation is the same as Create Table > Storage tab. Storage

Edit Table - Storage tab screen

Comment

Checks and modifies the existing comment information of the table to be modified.

Edit Table - Comment tab screen

After completing the modifications on each tab, apply the modifications by clicking the [Edit button] on the bottom right corner.