Deletes the specified index definition. If you attach to the database using the PATHNAME qualifier, SQL also deletes the index definition from the repository.