Skip to main content

DROP FUNCTION

Description​

Delete a custom function. Function names and parameter types are exactly the same to be deleted.

grammar:

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

Parameter Description:

  • function_name: the name of the function to delete
  • arg_type: the argument list of the function to delete

Example​

  1. Delete a function

    DROP FUNCTION my_add(INT, INT)
  2. Delete a global function

    DROP GLOBAL FUNCTION my_add(INT, INT)

Keywords​

 DROP, FUNCTION

Best Practice​