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.

Procedure

  • 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 in Cassandra 3.0 and later. 
    cqlsh> DROP MATERIALIZED VIEW cycling.cyclist_by_age;