DROP MATERIALIZED VIEW
Immediate, irreversible removal of a materialized view, including all data it contains. This operation has no effect on the base table.
Restriction: 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;