DROP-FUNCTION

Name

DROP FUNCTION

Description

This statement is used to delete a custom function. Please make sure the function names and parameter types are exactly correct.

Syntax:

DROP FUNCTION function_name
     (arg_type [, ...])

Parameter Description:

• function_name: the name of the function to be deleted
• arg_type: the argument list of the function to be deleted

Example

1. Delete a function

   DROP FUNCTION my_add(INT, INT)

Keywords

 DROP, FUNCTION

Best Practice