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

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
Sign Up Login You must be logged in to post a comment.