Removes a task from the current/specified schema.
DROP TASK [ IF EXISTS ] <name>
Specifies the identifier for the task to drop. If the identifier contains spaces, special characters, or mixed-case characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive (e.g.
If the task identifier is not fully-qualified (in the form of
schema_name.task_name), the command looks for the task in the current schema for the session.
Drop a task:
SHOW TASKS LIKE 't2%'; DROP TASK t2; SHOW TASKS LIKE 't2%';
Drop the task again, but don’t raise an error if the task does not exist:
DROP TASK IF EXISTS t2;