DROP TABLE
Synopsis
Use the DROP TABLE statement to remove a table and all of its data from the database.
Syntax
Diagram
Grammar
drop_table ::= DROP TABLE [ IF EXISTS ] table_name;
Where
table_nameis an identifier (possibly qualified with a keyspace name).
Semantics
- An error is raised if the specified
table_namedoes not exist unlessIF EXISTSoption is present. - Associated objects to
table_namesuch as prepared statements will be eventually invalidated after the drop statement is completed.
Examples
ycqlsh:example> CREATE TABLE users(id INT PRIMARY KEY, name TEXT);
ycqlsh:example> DROP TABLE users;