Delete a continuous query with DROP CONTINUOUS QUERY - Lindorm

Deletes a continuous query from a LindormTSDB database.

Applicable engines and versions

Applies to LindormTSDB only. Supported by all versions.

DROP CONTINUOUS QUERY [database_identifier.cq_identifier]

Parameter	Description
`database_identifier`	The name of the database that contains the continuous query. If omitted, defaults to the current database. Enclose the name in backticks. Example: ` db_sensor `
`cq_identifier`	The name of the continuous query to delete. Enclose the name in backticks. Example: ` my_cq `

To find the name of a continuous query, run SHOW CONTINUOUS QUERIES first.

Delete the continuous query my_cq from the db_sensor database:

DROP CONTINUOUS QUERY `db_sensor`.`my_cq`;