How to view all tables in CQL and CQLSH?

Ahmad Farid picture Ahmad Farid · Jul 10, 2018 · Viewed 10.5k times · Source

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?

Answer

Laxmikant picture Laxmikant · Jul 11, 2018

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>;