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 directed-query-id

Arguments

directed-query-id 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