Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ SQL Reference/ SQL Syntax/ DROP PROCEDURE
Updated on 2025-02-27 GMT+08:00
View PDF
Share

DROP PROCEDURE

Description

Drops a stored procedure.

Syntax

DROP PROCEDURE [ IF EXISTS  ] procedure_name ;

Parameters

  • IF EXISTS

    Reports a notice instead of an error if the specified stored procedure does not exist.

  • procedure_name

    Specifies the name of the stored procedure to be dropped.

    Value range: an existing stored procedure name.

Examples

See Examples in "CREATE PROCEDURE."

Helpful Links

CREATE PROCEDURE

Parent topic: SQL Syntax