[CASSANDRA-5060] select keyspace_name from system.schema_keyspaces

• Type: New Feature
• Status: Resolved
• Priority: Low
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: Legacy/CQL
• Assignee: Aleksey Yeschenko
• Reporter: Tupshin Harper

Authors

Aleksey Yeschenko

Reviewers

Brandon Williams

• Created: 12/Dec/12 19:38
• Updated: 16/Apr/19 09:32
• Resolved: 12/Dec/12 21:13

Description

It is currently possible to "describe tables" to list the tables in the current keyspace, or list all tables in all keyspaces if you are not currently in a keyspace. It is also possible to enumerate the keyspaces with a cql command to select from the system.schema_columnfamilies. There should be a simple "describe keyspaces" command that enumerates just the keyspaces and is syntactic sugar for "select keyspace name from schema_keyspaces".