Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.2Mb
PDF (A4) - 40.3Mb
PDF (RPM) - 39.9Mb
HTML Download (TGZ) - 10.5Mb
HTML Download (Zip) - 10.6Mb
HTML Download (RPM) - 9.2Mb
Man Pages (TGZ) - 239.9Kb
Man Pages (Zip) - 343.7Kb
Info (Gzip) - 3.9Mb
Info (Zip) - 3.9Mb
Excerpts from this Manual The user_defined_functions Table

The user_defined_functions table contains a row for each user-defined function (UDF) registered by a server component or plugin, or by a CREATE FUNCTION statement.

user_defined_functions has these columns:


    The UDF name as referred to in SQL statements. The value is NULL if the function was registered by a CREATE FUNCTION statement and is in the process of unloading.


    The UDF return value type. The value is one of int, decimal, real, char, or row.


    The UDF type. The value is one of function (scalar) or aggregate.


    The name of the UDF library file containing the executable UDF code. The file is located in the directory named by the plugin_dir system variable. The value is NULL if the UDF was registered using a server component service rather than by a CREATE FUNCTION statement.


    The current UDF usage count.

The user_defined_functions table has these indexes:

  • Primary key on (UDF_NAME)

TRUNCATE TABLE is not permitted for the user_defined_functions table.