DROP TABLE
Immediate, irreversible removal of a table, including all data contained in the table.
Restriction: 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: InvalidRequest: Error from server: code=2200 [Invalid query] message="Cannot drop table when materialized views still depend on it (cycling.{cyclist_by_age})"
See also: CREATE TABLE, ALTER TABLE, CREATE CUSTOM INDEX for Storage-Attached Indexes (SAI), CREATE INDEX for secondary indexes (2i)
Syntax
BNF definition:
drop_table_statement::= DROP TABLE [ IF EXISTS ] table_name
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. |
Required parameters
table_name
Name of the table to drop.
Optional parameters
keyspace_name
Name of the keyspace that contains the table to drop. If no name is specified, the current keyspace is used.
Examples
Drop the cyclist_name
table:
DROP TABLE IF EXISTS cycling.cyclist_name;