List index names

Tables with the Data API are currently in public preview. Development is ongoing, and the features and functionality are subject to change. Hyper-Converged Database (HCD), and the use of such, is subject to the DataStax Preview Terms.

Gets the names of the indexes for a table.

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

Python
TypeScript
Java
curl

Returns the index names for a table as an unordered list of strings.

Returns a promise that resolves to the index names for a table as an unordered list of strings.

Returns the index names for a table as an unordered list of strings.

Returns the index names for a table as an unordered list of strings in the status.indexes field of the response.

Example response:

{
  "status": {
    "indexes": [
      "index_name_1",
      "index_name_2"
    ]
  }
}

Parameters

Python
TypeScript
Java
curl

Use the list_index_names method, which belongs to the astrapy.Table class.

Method signature

list_index_names(
  *,
  table_admin_timeout_ms: int,
  request_timeout_ms: int,
  timeout_ms: int,
) -> list[str]

Name Type Summary

Name	Type	Summary
`table_admin_timeout_ms`	`int`	Optional. A timeout, in milliseconds, for the underlying HTTP request. If not provided, the `Table` defaults apply. This parameter is aliased as `request_timeout_ms` and `timeout_ms` for convenience.

table_admin_timeout_ms

int

Optional. A timeout, in milliseconds, for the underlying HTTP request. If not provided, the Table defaults apply. This parameter is aliased as request_timeout_ms and timeout_ms for convenience.

Use the listIndexes method, which belongs to the Table class.

Method signature

async listIndexes(
  options?: ListIndexOptions & {
    nameOnly: true,
    timeout?: number | TimeoutDescriptor,
  }
): TableIndexDescriptor[]

Name Type Summary

Name	Type	Summary
`options`	`ListIndexOptions`	The options for this operation. See Properties of `options` for more details.

options

ListIndexOptions

The options for this operation. See Properties of options for more details.

Properties of `options`
Name	Type	Summary
`nameOnly`	`true`	Must be `true` to return only the index names. Otherwise, index names and metadata are returned.
`timeout`	`number` \| `TimeoutDescriptor`	Optional. A timeout to impose on the underlying API request.

Use the listIndexesNames method, which belongs to the com.datastax.astra.client.tables.Table class.

Method signature

List<String> listIndexesNames()

List<String> listIndexesNames(ListIndexesOptions listIndexesOptions)

Name Type Summary

Name	Type	Summary
`options`	`ListIndexesOptions`	Optional. The options for this operation, including timeout.

options

ListIndexesOptions

Optional. The options for this operation, including timeout.

Use the listIndexes command.

Command signature

curl -sS -L -X POST "API_ENDPOINT/api/json/v1/KEYSPACE_NAME/TABLE_NAME" \
--header "Token: APPLICATION_TOKEN" \
--header "Content-Type: application/json" \
--data '{
  "listIndexes": {
    "options": {
      "explain": false
    }
  }
}'

Name Type Summary

Name	Type	Summary
`options.explain`	`false`	Must be `false` to return only the index names. Otherwise, index names and metadata are returned.

options.explain

false

Must be false to return only the index names. Otherwise, index names and metadata are returned.

Examples

The following examples demonstrate how to get the names of the indexes for a table.

List index names

Python
TypeScript
Java
curl

from astrapy import DataAPIClient
from astrapy.authentication import UsernamePasswordTokenProvider
from astrapy.constants import Environment

# Get an existing table
client = DataAPIClient(environment=Environment.HCD)
database = client.get_database(
    "API_ENDPOINT",
    token=UsernamePasswordTokenProvider("USERNAME", "PASSWORD"),
)
table = database.get_table("TABLE_NAME", keyspace="KEYSPACE_NAME")

# List index names
result = table.list_index_names()
print(result)

import {
  DataAPIClient,
  UsernamePasswordTokenProvider,
} from "@datastax/astra-db-ts";

// Get an existing table
const client = new DataAPIClient({ environment: "hcd" });
const database = client.db("API_ENDPOINT", {
  token: new UsernamePasswordTokenProvider("USERNAME", "PASSWORD"),
});
const table = database.table("TABLE_NAME", {
  keyspace: "KEYSPACE_NAME",
});

// List index names
(async function () {
  const result = await table.listIndexes({ nameOnly: true });

  console.log(result);
})();

import com.datastax.astra.client.DataAPIClient;
import com.datastax.astra.client.DataAPIClients;
import com.datastax.astra.client.databases.Database;
import com.datastax.astra.client.tables.Table;
import com.datastax.astra.client.tables.definition.rows.Row;
import java.util.List;

public class Example {

  public static void main(String[] args) {
    // Get an existing table
    DataAPIClient client = DataAPIClients.clientHCD("USERNAME", "PASSWORD");
    Database database = client.getDatabase("API_ENDPOINT", "KEYSPACE_NAME");
    Table<Row> table = database.getTable("TABLE_NAME");

    // List index names
    List<String> result = table.listIndexesNames();

    System.out.println(result);
  }
}

curl -sS -L -X POST "API_ENDPOINT/v1/KEYSPACE_NAME/TABLE_NAME" \
  --header "Token: APPLICATION_TOKEN" \
  --header "Content-Type: application/json" \
  --data '{
  "listIndexes": {
    "options": {
      "explain": false
    }
  }
}'

Client reference

Python
TypeScript
Java
curl

For more information, see the client reference.

Client reference documentation is not applicable for HTTP.

List index names

Result

Parameters

Examples

List index names

Client reference

Was this helpful?

Give Feedback