vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_06_0201.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

3.7 KiB
Raw Permalink Blame History

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 a stored procedure.

1
DROP PROCEDURE prc_add;

Helpful Links

CREATE PROCEDURE

Parent topic: DDL Syntax