DROP TABLE
Immediate, irreversible removal of a table, including all data contained in the table.
Drop all materialized views associated with the table before dropping the table. An error message lists any materialized views that are based on the table: |
Synopsis
DROP TABLE [ IF EXISTS ] [<keyspace_name>.]<table_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. |
Example
Drop the cyclist_name
table:
DROP TABLE IF EXISTS cycling.cyclist_name;