Dropping a keyspace, table or materialized view 

Steps for dropping keyspace, table or materialized view using the DROP command.

You drop a table or keyspace using the DROP command.


  • Drop the test keyspace.
    cqlsh> DROP KEYSPACE test;
  • Drop the cycling.last_3_days table.
    cqlsh> DROP TABLE cycling.last_3_days;
  • Drop the cycling.cyclist_by_age materialized view.
    cqlsh> DROP MATERIALIZED VIEW cycling.cyclist_by_age;