Products
High-quality database products to meet full lifecycle enterprise data management needs.
Resources
Various types of resources about OceanBase and the database industry
Docs
Rich content to meet the content demands of using products and solving product usage problems
OceanBase Database
Download PDF
OceanBase, A Highly Scalable Database for Transactional, Analytical, and AI Workloads.
Resources
© OceanBase 2024. All rights reserved | Cloud Service Agreement | Privacy Policy | Legal | Security
OceanBase DatabaseYou can use the DROP PROCEDURE statement to drop a stored procedure.
The syntax is as follows:
DROP PROCEDURE [IF EXISTS] sp_name
To drop a stored routine, you must have the ALTER ROUTINE privilege on the routine.
If the stored procedure does not exist, you can use the IF EXISTS clause to avoid errors and generate a warning. You can use the SHOW WARNINGS statement to view the warning.
Here is an example:
obclient> DROP PROCEDURE IF EXISTS proc_name;
Query OK, 0 rows affected