Drop Step

Summary

The DROP STEP command removes the specified step domain object from the Connect instance.

Syntax

drop step [if exists] <step_name>;

Parameters

Parameter
Description
[if exists] (Optional) Suppresses error messages when a user attempts to drop a non-existent step. Connect will report an error if the step does not exist and [if exists] is omitted.
<step_name> (Required) The name of the step to remove.

Details

 

Pipelines that have member references to a step will retain those references even after the step is dropped. The pipeline will subsequently fail to run when invoked. Use ALTER PIPELINE to remove any invalid steps from an existing pipeline object or recreate the affected pipeline definition.

screen-shot-2016-09-22-at-8-42-21-am

Examples

drop step s_lookup_period_name;

screen-shot-2016-09-22-at-8-42-50-am

 

drop step if exists s_drop_tmp_table;

screen-shot-2016-09-22-at-8-42-38-am

 

Related Commands

ALTER PIPELINE

ALTER STEP

CREATE STEP

INVOKE STEP

SHOW STEP

SHOW STEPS

CREATE SNAPSHOT

REVERT (to a snapshot)