Search code examples
cassandracql3column-family

CQL3 Show Column Families

Can anybody tell how to get a list of column families under the current key space in Cassandra 2.0.4?

Kindly note that am using cqlsh to query the server.

Solution

  • In addition to Svend's very concise answer, you can also query system.schema_columnfamilies with the name of the keyspace in question:

    SELECT columnfamily_name 
FROM system.schema_columnfamilies
WHERE keyspace_name='myKeyspaceName';