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;