Online Documentation for SQL Manager for InterBase/Firebird

Fields


Table fields are managed within the Fields tab of Table 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 field:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click the field to rename and select the Rename Field <field_name>... item from the context menu;
  • edit the field name using the Rename Object... dialog.

To change the order of table fields:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click a field and select the Reorder Fields context menu item;
  • edit fields' order using the Reorder Fields 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, or press the Del key;
  • confirm dropping in the dialog window.