DROP FUNCTION

DROP FUNCTION deletes an existing function.

To delete an overloaded function, you must specify the function's parameter (argument) type. For non-overloaded functions, you can delete them by just specifying the function name.
If a function involves operations on temporary tables, the function cannot be deleted by running DROP FUNCTION.

     
          DROP FUNCTION [ IF EXISTS ] function_name 
[ ( [ {[ argmode ] [ argname ] argtype} [, ...] ] ) [ CASCADE | RESTRICT ] ];

**Table 1** DROP FUNCTION parameters
Parameter	Description	Value Range
IF EXISTS	Sends a notice instead of an error if the specified table does not exist.	-
function_name	Specifies the name of the function to be deleted.	Use an existing function name.
argmode	Specifies the mode of a function parameter.	-
argname	Specifies the name of a function parameter.	-
argtype	Specifies the data type of a function parameter.	-
CASCADE \| RESTRICT	Specifies how to process related data in the dependent object when a delete operation is performed.	CASCADE: automatically deletes all objects that depend on the function to be deleted (such as operators). RESTRICT: refuses to delete the function if any objects depend on it. This is the default.

Delete a function named add_two_number:

     
          DROP FUNCTION add_two_number;

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.