Support Forums : DataStax

Extract the column families of a given keyspace by a CQL query

(3 posts) (2 voices)

Tags:

No tags yet.

keulkeul
Member

Hi,

I would to know if CQL can extract all column families from a given keyspace ?

I supposed i need to query the system keyspaces ...

Thanks a lot

Mickael

Posted 5 months ago #
khahn
Member

On the CQLsh command line you can use the DESCRIBE command to output a list of CQL commands that could be used to recreate the given table, as described in http://www.datastax.com/docs/1.2/cql_cli/cql/DESCRIBE#cqlsh-describe.

Posted 5 months ago #
keulkeul
Member

Hi,

Thanks a lot. I preferred use a query on schema_columnfamilies like this

SELECT columnfamily_name FROM schema_columnfamilies WHERE keyspace_name = 'cassandrademocql';

Mickael

Posted 5 months ago #