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.
Signature
Use the dropTableIndex method, which belongs to the com.datastax.astra.client.databases.Database class.
void dropTableIndex(String indexName)void dropTableIndex(
String indexName,
DropTableIndexOptions dropIndexOptions
)Parameters
| Name | Type | Summary |
|---|---|---|
|
|
Name of the index to drop |
|
The options for this operation. See Methods of the |
| Method | Parameters | Summary |
|---|---|---|
|
|
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 |
|
|
Optional. The keyspace where you created the index. Default: The working keyspace for the database.
This is |
|
|
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.
