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
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.
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
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
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
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
Comment
Checks and modifies the existing comment information of the table to be modified.
After completing the modifications on each tab, apply the modifications by clicking the [Edit button] on the bottom right corner.
Last updated