Categories:

Table, View, & Sequence DDL

DROP TASK

Removes a task from the current/specified schema.

See also:

CREATE TASK , SHOW TASKS

Syntax

DROP TASK [ IF EXISTS ] <name>

Parameters

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. "My Object").

If the task identifier is not fully-qualified (in the form of db_name.schema_name.task_name or schema_name.task_name), the command looks for the task in the current schema for the session.

Examples

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;