Drop an index (Java)

Deletes an index from a table in a database.

Ready to write code? See the examples for this method to get started. If you are new to the Data API, check out the quickstart.

Result

Deletes the specified index.

Does not return anything.

Parameters

Use the dropTableIndex method, which belongs to the com.datastax.astra.client.databases.Database class.

Method signature
void dropTableIndex(String indexName)
void dropTableIndex(
  String indexName,
  DropTableIndexOptions dropIndexOptions
)
Name Type Summary

name

str

Name of the index to drop

options

DropTableIndexOptions

The options for this operation. See Methods of the DropTableIndexOptions class for more details.

Methods of the DropTableIndexOptions class
Method Parameters Summary

ifExists()

boolean

Optional. Whether the command should silently succeed even if an index with the given name does not exist in the keyspace and no index was dropped.

Default: false

keyspace()

String

Optional. The keyspace where you created the index.

Default: The working keyspace for the database. This is default_keyspace unless you set a different working keyspace when you created the Database object.

timeout()

long | Duration

Optional. The timeout(s) to apply to HTTP request(s) originating from this method.

Examples

The following examples demonstrate how to drop an index from a table.

Drop an index

import com.datastax.astra.client.DataAPIClient;
import com.datastax.astra.client.databases.Database;

public class Example {

  public static void main(String[] args) {
    // Get a database
    Database database = new DataAPIClient("APPLICATION_TOKEN").getDatabase("API_ENDPOINT");

    // Drop an index
    database.dropTableIndex("INDEX_NAME");
  }
}

Drop an index only if the index exists

Use this option to silently do nothing if an index with the specified name does not exist.

import com.datastax.astra.client.DataAPIClient;
import com.datastax.astra.client.databases.Database;
import com.datastax.astra.client.tables.commands.options.DropTableIndexOptions;

public class Example {

  public static void main(String[] args) {
    // Get a database
    Database database = new DataAPIClient("APPLICATION_TOKEN").getDatabase("API_ENDPOINT");

    // Drop an index
    DropTableIndexOptions options = new DropTableIndexOptions().ifExists(true);

    database.dropTableIndex("INDEX_NAME", options);
  }
}

Client reference

For more information, see the client reference.

Was this helpful?

Give Feedback

How can we improve the documentation?

© Copyright IBM Corporation 2026 | Privacy policy | Terms of use Manage Privacy Choices

Apache, Apache Cassandra, Cassandra, Apache Tomcat, Tomcat, Apache Lucene, Apache Solr, Apache Hadoop, Hadoop, Apache Pulsar, Pulsar, Apache Spark, Spark, Apache TinkerPop, TinkerPop, Apache Kafka and Kafka are either registered trademarks or trademarks of the Apache Software Foundation or its subsidiaries in Canada, the United States and/or other countries. Kubernetes is the registered trademark of the Linux Foundation.

General Inquiries: Contact IBM