<a id="ksqldb-reference-drop-table"></a>

# DROP TABLE statement in ksqlDB for Confluent Platform

## Synopsis

```sql
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` or `PROTOBUF`,
the corresponding 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`. You
should check 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.
