DROP SAVED QUERY

DROP_SAVED_QUERY drops a previously saved query.

Read more in the saved_queries guide.

See also: SAVE QUERY, EXECUTE SAVED QUERY, DESCRIBE SAVED QUERY, RECOMPILE SAVED QUERY, and DESCRIBE SAVED QUERIES LIST.

Permissions

Dropping a saved query requires no special permissions.

Syntax

SELECT DROP_SAVED_QUERY("<saved_query_name>")

Returns

If saved query is dropped successfully, returns nothing.

Parameters

Parameter	Parameter Type	Description
saved_query_name	Identifier	The name of the query to drop

Examples

SELECT DROP_SAVED_QUERY(select_all);