Index Editor

Previous  Top  Next

From the Index Editor, you can create, alter and drop indices.

 

Again, depending on the database engine capabilities, you will have a different user interface, however the "left-right" interface will always be available. On the left, you have the available columns (usually all non-computed columns in a table) and on the right, the indexed columns, first indexed column at the top.

 

Below is an example from the InterBase Index Editor:

The InterBase Index Editor

 

In order to create a new index, you first need to select a table from the drop down box.

 

Double clicking a column or using the arrow buttons will move the column to the other side, making the column indexed or non-indexed.