Removes a pipeline declaration from the current session's pipeline registry.
DROP PIPELINE [IF EXISTS] <name>## Overview DROP PIPELINE removes a pipeline declaration from the executor's in-session pipeline registry. Pipeline declarations registered via the PIPELINE statement live in a session-local list; DROP PIPELINE unregisters one entry from that list. ## Behavior - The pipeline registry is session-scoped (an in-memory `Vec<PipelineCommand>` on the executor). The drop affects the current session only and is not persisted to any catalog table. - Without IF EXISTS, dropping a name that was never declared raises an error. With IF EXISTS, the operation succeeds silently. - DROP PIPELINE removes the declaration; it does not touch any historical pipeline runs, schedules referenced by the declaration, or workspace-level metadata managed elsewhere. - Re-declaring a pipeline with the same name in the same session after DROP creates a fresh registry entry. ## Access Control No specific privilege is required beyond what the session already holds. ## Compatibility DeltaForge extension.
| Name | Type | Description |
|---|---|---|
name | Specifies the pipeline name to drop. Must match the name supplied at the PIPELINE declaration. | |
if_exists | Skip silently when no pipeline with that name has been declared in the current session. |
-- Drop a known pipeline declared earlier in the script
DROP PIPELINE my_etl_pipeline;-- Idempotent drop
DROP PIPELINE IF EXISTS my_etl_pipeline;