Online Documentation for SQL Manager for InterBase/Firebird

Indices


Table indexes are managed within the Indices tab of Table Editor.

 

Creating Indices

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

 

Editing Indices

To edit an existing table index:

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

To change the name of an index:

  • open the table in Table Editor;
  • proceed to the Indices tab there;
  • right-click the index to rename and select the Rename Index <index_name>... item from the context menu;
  • edit the index name using the Rename Object... dialog.

 

Dropping Indices

  • open the table in Table Editor;
  • proceed to the Indices tab there;
  • right-click the index and select the Drop Index <index_name> context menu item, or press the Del key;
  • confirm dropping in the dialog window.