Removes a schedule declaration from the current session's schedule registry.
DROP SCHEDULE [IF EXISTS] <name>
## Overview DROP SCHEDULE removes a schedule declaration from the executor's in-session schedule registry. SCHEDULE declarations live in a session-local list; DROP SCHEDULE unregisters one entry from that list. ## Behavior - The schedule registry is session-scoped. The drop affects the current session only and is not persisted. - Pipelines that reference the schedule by name keep the string reference unchanged. After the schedule is dropped, those pipelines no longer resolve the schedule when their cron is consulted; the reference becomes a dangling name. - Without IF EXISTS, dropping an undeclared schedule raises an error. With IF EXISTS, the operation succeeds silently. ## Access Control No specific privilege is required beyond what the session already holds. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
name | Specifies the schedule name to drop. | |
if_exists | Skip silently when no schedule with that name has been declared in the current session. |
-- Drop a known schedule
DROP SCHEDULE daily_etl;
-- Idempotent drop
DROP SCHEDULE IF EXISTS daily_etl;