## Synopsis Use the `DROP TABLE` statement to remove a table and all of its data from the database. ## Syntax ### Diagram ### Grammar ```ebnf drop_table ::= DROP TABLE [ IF EXISTS ] table_name; ``` Where - `table_name` is an identifier (possibly qualified with a keyspace name). ## Semantics - An error is raised if the specified `table_name` does not exist unless `IF EXISTS` option is present. - Associated objects to `table_name` such as prepared statements will be eventually invalidated after the drop statement is completed. ## Examples ```sql ycqlsh:example> CREATE TABLE users(id INT PRIMARY KEY, name TEXT); ``` ```sql ycqlsh:example> DROP TABLE users; ``` ## See also - [`ALTER TABLE`](../ddl_alter_table) - [`CREATE TABLE`](../ddl_create_table) - [`DELETE`](../dml_delete/) - [`INSERT`](../dml_insert) - [`SELECT`](../dml_select/) - [`UPDATE`](../dml_update/)