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;