cql: show tables in a keystone

2013-01-28 Thread Paul van Hoven
Is there some way in cql to get a list of all tables or column
families that belong to a keystore like show tables in sql?


Re: cql: show tables in a keystone

2013-01-28 Thread Brian O'Neill

cqlsh use keyspace;
cqlsh:cirrus describe tables;

For more info:
cqlsh help describe

-brian


---
Brian O'Neill
Lead Architect, Software Development
Health Market Science
The Science of Better Results
2700 Horizon Drive € King of Prussia, PA € 19406
M: 215.588.6024 € @boneill42 http://www.twitter.com/boneill42  €
healthmarketscience.com

This information transmitted in this email message is for the intended
recipient only and may contain confidential and/or privileged material. If
you received this email in error and are not the intended recipient, or
the person responsible to deliver it to the intended recipient, please
contact the sender at the email above and delete this email and any
attachments and destroy any copies thereof. Any review, retransmission,
dissemination, copying or other use of, or taking any action in reliance
upon, this information by persons or entities other than the intended
recipient is strictly prohibited.
 






On 1/28/13 2:27 PM, Paul van Hoven paul.van.ho...@googlemail.com wrote:

Is there some way in cql to get a list of all tables or column
families that belong to a keystore like show tables in sql?




Re: cql: show tables in a keystone

2013-01-28 Thread Theo Hultberg
the DESCRIBE family of commands in cqlsh are wrappers around queries to the
system keyspace, so if you want to inspect what keyspaces and tables exist
from your application you can do something like:

SELECT columnfamily_name, comment
FROM system.schema_columnfamilies
WHERE keyspace_name = 'test';

or

SELECT * FROM system.schema_keyspaces;

T#


On Mon, Jan 28, 2013 at 8:35 PM, Brian O'Neill b...@alumni.brown.eduwrote:


 cqlsh use keyspace;
 cqlsh:cirrus describe tables;

 For more info:
 cqlsh help describe

 -brian


 ---
 Brian O'Neill
 Lead Architect, Software Development
 Health Market Science
 The Science of Better Results
 2700 Horizon Drive € King of Prussia, PA € 19406
 M: 215.588.6024 € @boneill42 http://www.twitter.com/boneill42  €
 healthmarketscience.com

 This information transmitted in this email message is for the intended
 recipient only and may contain confidential and/or privileged material. If
 you received this email in error and are not the intended recipient, or
 the person responsible to deliver it to the intended recipient, please
 contact the sender at the email above and delete this email and any
 attachments and destroy any copies thereof. Any review, retransmission,
 dissemination, copying or other use of, or taking any action in reliance
 upon, this information by persons or entities other than the intended
 recipient is strictly prohibited.







 On 1/28/13 2:27 PM, Paul van Hoven paul.van.ho...@googlemail.com
 wrote:

 Is there some way in cql to get a list of all tables or column
 families that belong to a keystore like show tables in sql?