This topic describes the SQL syntax that is used to delete a continuous query.
drop_cq_statement ::= DROP CONTINUOUS QUERY [database_name.]cq_name
The name of the database in which you perform a continuous query on objects. If you do not specify this parameter, the name of the database that you use is specified.
The name of the continuous query.
The following sample code provides an example on how to delete the continuous query that is created in the CREATE CONTINUOUS QUERY topic:
DROP CONTINUOUS QUERY `db_sensor`.`my_cq`;