Re: Extract meta-data using cql 3

2013-07-12 Thread Theo Hultberg
there's a keyspace called system which has a few tables that contain the metadata. for example schema_keyspaces that contain keyspace metadata, and schema_columnfamilies that contain table metadata. there are more, just fire up cqlsh and do a describe keyspace in the system keyspace to find them.

Re: Extract meta-data using cql 3

2013-07-12 Thread Sylvain Lebresne
The "raw" answer is that you should query the system tables. The schema is stored in the 3 following tables: System.schema_keyspaces, System.schema_columnfamilies and System.schema_columns. Unfortunately, the information stored in there is, for different reasons, not in a form that makes a lot of s

Extract meta-data using cql 3

2013-07-12 Thread Murali
Hi experts, How to extract meta-data of a table or a keyspace using CQL 3.0? -- Thanks, Murali