JDBC Driver for Couchbase

Build 24.0.9060

ListIndices

Lists all indices available in Couchbase

Result Set Columns

Name Type Description
Id String The unique index ID
Datastore_id String The server hosting the indexed bucket
Namespace_id String The pool hosting the indexed bucket
Bucket_id String The bucket the index applies to if the index applies to a collection (Couchbase 7 and up). NULL otherwise.
Scope_id String The scope the index applies to if the index applies to a collection (Couchbase 7 and up). NULL otherwise.
Keyspace_id String The collection the index applies to, if the index applis to a collection (Couchbase 7 and up). The bucket the index applies to otherwise.
Index_key String A list of keys participating in the index
Condition String The N1QL filter that the index applies to
Is_primary String Whether the index is on the primary key
Name String The name of the index
State String Whether the index is available
Using String Whether the index is backed by GSI or a view

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060