Indices

Table indices are managed on the Indices tab of the Table Editor. You can also access table indices via the Databases tab of the DB Explorer (if option Show Table Subobjects is on) or via the SQL Assistant area (if the Tables' Details switch is set to Show Indices).

Create Index

To add an index to the table

1

Open the table in the Table Editor.

2

Open the Indices tab.

3

Right-click and select the New Index item from the popup menu.

This opens the Index Editor dialog, where you can set the index name and include fields into the index.

Edit Index

To edit the table index

1

Open the table in the Table Editor.

2

Open the Indices tab.

3

Double-click the index to edit.

or

4   Right-click on the index and select the Edit Index <Index_Name> item from the popup menu.

Now the index is available for editing in the Index Editor dialog.

Drop Index

      
To drop the table index

1

Open the table in the Table Editor.

2

Open the Indices tab.

3

Right-click on the index to drop and select the Drop Index item from the popup menu.