DROP_SAVED_QUERY

DROP_SAVED_QUERY drops a previously saved query.

Read more in the Saved queries guide.

See also: ref:save_query, EXECUTE_SAVED_QUERY, ref:show_saved_query, ref:list_saved_queries.

Permissions

Dropping a saved query requires no special permissions.

Syntax

drop_saved_query_statement ::=
    SELECT DROP_SAVED_QUERY(saved_query_name)
    ;

saved_query_name ::= string_literal

Returns

If saved query is dropped successfully, returns nothing.

Parameters

Parameter Description
saved_query_name The name of the query to drop

Examples

Dropping a previously saved query

t=> SELECT DROP_SAVED_QUERY('select_all');
executed