Dropping a materialized view
Drop materialized views with the DROP MATERIALIZED VIEW command.
Procedure
Drop the cycling.cyclist_by_age materialized view in
DataStax Enterprise (DSE) 5.0 and later.
DROP MATERIALIZED VIEW cycling.cyclist_by_age;