How to view all tables in CQL and CQLSH?

Question

I'm trying to explore the database and want to see all tables that exist there. What's the command that's equivalent to SHOW TABLES; in SQL?

score 17 · Accepted Answer · edited Jul 11 '18 at 05:46

17

to get all table names : DESC tables;

to get detailed view of a table : DESC table <table_name>;

to get detailed view of all tables in a keyspace : DESC keyspace <keyspace_name>;

edited Jul 11 '18 at 05:46

LuFFy

answered Jul 11 '18 at 04:26

Laxmikant

score 9 · Answer 2 · answered Jul 10 '18 at 21:52

9

Yes, you can use the DESCRIBE command:

DESCRIBE tables;

answered Jul 10 '18 at 21:52

NiVeR

adinas · Answer 3 · 2019-11-25T15:31:45.373

3

Depending on the version of Cassandra, the following may work for you

SELECT * FROM system_schema.tables

Check out the other tables in the system_schema keyspace to see what other info you can get

edited Nov 25 '19 at 15:31

answered Nov 25 '19 at 14:51

adinas

3 Answers3