SHOW CREATE FUNCTION

description

  1. The statement is used to show the creation statement of user-defined function
  2. grammar:
  3. SHOW CREATE FUNTION function_name(arg_type [, ...]) [FROM db_name]];
  4. Description:
  5. `function_name`: the name of the function to be displayed
  6. `arg_type`: the parameter list of the function to be displayed
  7. If you do not specify db_name, use the current default db

example

  1. 1. Show the creation statement of the specified function under the default db
  2. SHOW CREATE FUNCTION my_add(INT, INT)

keyword

  1. SHOW,CREATE,FUNCTION