How to Drop a Persistent Query in ksqlDB

In ksqlDB, the DROP QUERY or DROP PERSISTENT QUERY statements don’t exist.

Instead, you need to use a TERMINATE statement:

TERMINATE query_id;

This will drop the persistent query that is running.

Read about How to describe a query to know more about the query you want to terminate, and How to list persistent queries if you need to know about other queries.