CQL3 Show Column Families

Question

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.

Answer 1

This should do:

desc tables;

Also, not that cqlsh support tab-completion (à la bash), so pressing in the middle of a use or selectstatement also provides available parameter values.

Answer 2

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';