DROP DIRECTED QUERY

Removes a directed query from the database. If the directed query is active, Vertica deactivates it before removal.

Syntax

DROP DIRECTED QUERY directedqueryID

Arguments

directedqueryID Identifies the directed query to remove from the database. To obtain identifiers for directed queries, use GET DIRECTED QUERY, or query the system table V_CATALOG.DIRECTED_QUERIES.

Privileges

Superuser