Documentation Home
MySQL 8.0 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 38.1Mb
PDF (A4) - 38.1Mb
PDF (RPM) - 33.0Mb
HTML Download (TGZ) - 8.1Mb
HTML Download (Zip) - 8.1Mb
HTML Download (RPM) - 7.0Mb
Man Pages (TGZ) - 132.7Kb
Man Pages (Zip) - 188.9Kb
Info (Gzip) - 3.4Mb
Info (Zip) - 3.4Mb
Excerpts from this Manual

25.11.16.4 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:

  • UDF_NAME

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

  • UDF_RETURN_TYPE

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

  • UDF_TYPE

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

  • UDF_LIBRARY

    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.

  • UDF_USAGE_COUNT

    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
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
Sign Up Login You must be logged in to post a comment.