Check secondary index (2i) existence

Check if an index exists and view its definition using the DESCRIBE TABLE command.

Prerequisites

Keyspace created
Table created

Secondary index (2i) created

Verify that an index exists:
```
DESCRIBE INDEX cycling.blist_keys_idx;
```

View the index definition:

WARNING: cqlsh was built against 5.0-beta1, but this server is 5.0.  All features may not work!

CREATE CUSTOM INDEX blist_keys_idx ON cycling.birthday_list (keys(blist)) USING 'sai';

Was this helpful?