DROP MATERIALIZED VIEW
Immediate, irreversible removal of a materialized view, including all data it contains. This operation has no effect on the base table.
| 
 Drop all materialized views associated with a base table before dropping the table.  | 
Synopsis
DROP MATERIALIZED VIEW [ IF EXISTS ] [<keyspace_name>.]<view_name> ;
Syntax legend
| Syntax conventions | Description | 
|---|---|
UPPERCASE  | 
Literal keyword.  | 
Lowercase  | 
Not literal.  | 
  | 
Variable value. Replace with a user-defined value.  | 
  | 
Optional.
Square brackets (  | 
  | 
Group.
Parentheses (   | 
  | 
Or.
A vertical bar (  | 
  | 
Repeatable.
An ellipsis (   | 
  | 
Single quotation (  | 
  | 
Map collection.
Braces (  | 
Set, list, map, or tuple.
Angle brackets (   | 
|
  | 
End CQL statement.
A semicolon (  | 
  | 
Separate the command line options from the command arguments with two hyphens (   | 
  | 
Search CQL only: Single quotation marks (  | 
  | 
Search CQL only: Identify the entity and literal value to overwrite the XML element in the schema and solrConfig files.  | 
- IF EXISTS
 - 
If the materialized view does not exist, the operation fails without an error. Optional.
 - <keyspace_name>
 - 
To drop a materialized view in a keyspace other than the current keyspace, put the keyspace name in front of the materialized view name, followed by a period.
 - <view_name>
 - 
The name of the materialized view to drop.
 
Example
Drop the cyclist_by_age materialized view from the cyclist keyspace.
DROP MATERIALIZED VIEW IF EXISTS cycling.cyclist_by_age;