DROP DIRECTED QUERY
Removes a directed query from the database.
Removes a directed query from the database. If the directed query is active, Vertica deactivates it before removal.
Syntax
DROP DIRECTED QUERY { query-name | where-clause }
Arguments
query-name- Name of the directed query to remove from the database, as stored in the DIRECTED_QUERIES column
query_name. You can also use GET DIRECTED QUERY to obtain names of all directed queries that map to an input query. where-clause- Resolves to one or more directed queries that are filtered from system table DIRECTED_QUERIES. For example, the following statement specifies to drop all directed queries with the same
save_plans_versionidentifier:=> DROP DIRECTED QUERY WHERE save_plans_version = 21;