All Products
Search
Document Center

Lindorm:DROP CONTINUOUS QUERY

Last Updated:Aug 24, 2022

This topic describes the SQL syntax that is used to delete a continuous query.

Syntax

drop_cq_statement ::= DROP CONTINUOUS QUERY [database_name.]cq_name

Parameters

Parameter

Description

database_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.

cq_name

The name of the continuous query.

Example

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`;