List index names

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
C#
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
C#
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 ListIndexNamesAsync method, which belongs to the Table class. You can also use ListIndexNames, which is the synchronous version of the method.

Method signature

public Task<List<string>> ListIndexNamesAsync(
  ListIndexNamesOptions options = null
);

Name Type Summary

Name	Type	Summary
`options`	`ListIndexNamesOptions`	Optional. General API options for this operation, including the keyspace and timeout. Keyspace is required unless you specified a keyspace when instantiating the `Database` object. For more information and examples, see Customize API interaction.

options

ListIndexNamesOptions

Optional. General API options for this operation, including the keyspace and timeout. Keyspace is required unless you specified a keyspace when instantiating the Database object. For more information and examples, see Customize API interaction.

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
C#
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.DataAPIClients;
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
    Table<Row> table =
        DataAPIClients.clientHCD("USERNAME", "PASSWORD")
            .getDatabase("API_ENDPOINT", "KEYSPACE_NAME")
            .getTable("TABLE_NAME");

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

    System.out.println(result);
  }
}

using System.Text.Json;
using DataStax.AstraDB.DataApi;
using DataStax.AstraDB.DataApi.Core;

namespace Examples;

public class Program
{
  static async Task Main()
  {
    // Get an existing table
    var client = new DataAPIClient(
      new CommandOptions() { Destination = DataAPIDestination.HCD }
    );

    var database = client.GetDatabase(
      "API_ENDPOINT",
      DataAPIClient.UsernamePasswordTokenProvider(
        "USERNAME",
        "PASSWORD"
      ),
      "KEYSPACE_NAME"
    );

    var table = database.GetTable("TABLE_NAME");

    // List index names
    var names = await table.ListIndexNamesAsync();
    Console.WriteLine(JsonSerializer.Serialize(names));
  }
}

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
C#
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