From the Ad Hoc Index Browser, the Delete command from the Ad Hoc Index menu enables you to remove (delete) the ad hoc index definition that is currently selected in the table on the browser if the index is not in the process of being built.
You cannot delete an ad hoc index that is currently being read by an ODBC driver.
To delete an ad hoc index
In the Ad Hoc Index Browser, select the index definition that you want to remove.
Select the Delete command from the Ad Hoc Index menu. A message box is then displayed, to enable you to confirm that you do want to delete the specified index definition.
Click the Yes button to confirm that the selected ad hoc index definition is to be deleted. Alternatively, click the No button to abandon the deletion.
If the index is fully built, the index is dropped and then deleted. The Ad Hoc Index Browser is then updated to reflect the deletion of the selected index definition. There may be a momentary delay while this updating occurs.