Some Cassandra/CQLSH Queries

1) Peers Info:
select peer, data_center from system.peers;

2) Tables Info:
select table_name from system_schema.tables where keyspace_name='xxx';
select keyspace_name, table_name, id from system_schema.tables; (To know table id)

3) Token Info:
select token(partition_key, clustering_column) from keyspace.table_name;
select keyspace_name, table_name from system_schema.tables where keyspace_name IN ('keyspace1', 'keyspace2', 'keyspace3');

4) Keyspaces info:
select * from system_schema.keyspaces;

5) Index Info:
select * from system."IndexInfo";
DSE Related Search-Index Query:
describe active search index schema on keyspace_name.table_name;
alter search index schema on table_name drop field column_name;

***