Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ DROP PROCEDURE
Updated on 2024-09-02 GMT+08:00
View PDF
Share

DROP PROCEDURE

Function

DROP PROCEDURE deletes an existing stored procedure.

Precautions

None.

Syntax

1
 
DROP PROCEDURE [ IF EXISTS  ] procedure_name ;

Parameter Description

  • IF EXISTS

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

  • procedure_name

    Specifies the name of the stored procedure to be deleted.

    Value range: An existing stored procedure name.

Examples

Delete the stored procedure:

1
 
DROP PROCEDURE prc_add;

Helpful Links

CREATE PROCEDURE

Parent topic: DDL Syntax