Dropping Directed Queries
DROP DIRECTED QUERY
removes the specified directed query from the database catalog. If the directed query is active, Vertica deactivates it before removal.
For example:
=> DROP DIRECTED QUERY findBostonCashiers_CUSTOM; DROP DIRECTED QUERY