Index Editor

Data Tool's Index Editor likely looks as you would expect. When you open the dialog, it will display the existing indexes for the table highlighted in the SQL Console window's object list. You can add and remove columns from the existing selected index. Just remember when you are creating a new index, that you have to click 'Create' and name the index before you can add columns to it.

How to create an index

  1. Select a table in the main window's (SQL Console's) object list.
  2. Click the Index button, below the object list. The Index Editor will open.

    3. Index Editor

  3. In the Index Editor, click the 'Create' button. An input dialog will appear where you enter the new index name. The default is to use the name of any selected column in creating the index name.
  4. Click the "OK" button.
  5. Double-click items in the 'Available Columns' listbox on the right side of the editor to add new columns to the index.
  6. Click 'Go' to replace the generated DDL into the SQL Console, close the editor, and run the statements.

Back to Table of Contents.