DROP TABLE

Synopsis

DROP TABLE [IF EXISTS] table_name [DELETE TOPIC];

Description

Drops an existing table.

If the DELETE TOPIC clause is present, the table's source topic is marked for deletion. If the topic format is AVRO, the corresponding Avro schema is deleted in the schema registry. Topic deletion is asynchronous, and actual removal from brokers may take some time to complete.

Note

DELETE TOPIC will not necessarily work if your Kafka cluster is configured to create topics automatically with auto.create.topics.enable=true. We recommended checking after a few minutes to ensure that the topic was deleted.

If the IF EXISTS clause is present, the statement doesn't fail if the table doesn't exist.

Example

TODO: example

Page last revised on: 2020-02-10


Last update: 2020-02-10