Online Documentation for SQL Manager for Oracle

Fields


Table/view/materialized view fields are managed within the Fields tab of Table Editor/View Editor/Materialized View Editor.

 

Creating Fields

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click the tab area and select the New Field context menu item, or press the Ins key;
  • define the field properties using the Field Editor dialog.

 

Editing Fields

To edit an existing table field:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click the field and select the Edit Field <field_name> context menu item, or simply double-click the field;
  • edit the field properties using the Field Editor dialog.

To change the name of a table field:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click a field and select the Rename Object... context menu item;
  • specify a new name for the field in the Rename Object... dialog.

 

Dropping Fields

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click the field and select the Drop Field <field_name> context menu item;
  • confirm dropping in the dialog window.