How to Drop a Table in ksqlDB

To delete a table, use a DROP statement:

DROP table_name;

A materialized table also has a persistent query updating its state and an underlying compacted topic that contains that state.

To also clean those two, when dropping the table make sure to add the DELETE TOPIC modifier:

DROP table_name DELETE TOPIC;

Not sure if the table is materialized? Read how to know if a table is materialized.