Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 37.7Mb
PDF (A4) - 37.8Mb
PDF (RPM) - 32.8Mb
HTML Download (TGZ) - 8.0Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 6.9Mb
Man Pages (TGZ) - 133.1Kb
Man Pages (Zip) - 189.6Kb
Info (Gzip) - 3.3Mb
Info (Zip) - 3.3Mb
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. 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 UDF library file. 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.

User Comments
Sign Up Login You must be logged in to post a comment.