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 FUNCTION statement to drop a stored function.
Syntax:
DROP FUNCTION [IF EXISTS] sp_name
To drop a stored routine, you must have the ALTER ROUTINE privilege on the routine.
If the stored function 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.
Example:
obclient> DROP FUNCTION IF EXISTS my_func;
Query OK, 0 rows affected