<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="obtaining-loadable-function-information">
      </a>
      7.7.2 Obtaining Information About Loadable Functions
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045254153008">
  </a>
  <a class="indexterm" name="idm46045254151552">
  </a>
  <a class="indexterm" name="idm46045254150048">
  </a>
  <a class="indexterm" name="idm46045254148560">
  </a>
  <p>
   The Performance Schema
   <a class="link" href="performance-schema-user-defined-functions-table.html" title="29.12.22.10 The user_defined_functions Table">
    <code class="literal">
     user_defined_functions
    </code>
   </a>
   table contains
      information about the currently installed loadable functions:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa65710569"><div class="copy-help left">Press ⌘+C to copy</div> <div class="right"><button class="clipboard-btn" title="Copy to Clipboard"><span class="icon-clipboard"></span></button></div></div><code class="language-sql"><span class="token keyword">SELECT</span> <span class="token operator">*</span> <span class="token keyword">FROM</span> performance_schema<span class="token punctuation">.</span>user_defined_functions<span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   The
   <code class="literal">
    mysql.func
   </code>
   system table also lists
      installed loadable functions, but only those installed using
   <a class="link" href="create-function-loadable.html" title="15.7.4.1 CREATE FUNCTION Statement for Loadable Functions">
    <code class="literal">
     CREATE
      FUNCTION
    </code>
   </a>
   . The
   <a class="link" href="performance-schema-user-defined-functions-table.html" title="29.12.22.10 The user_defined_functions Table">
    <code class="literal">
     user_defined_functions
    </code>
   </a>
   table lists
      loadable functions installed using
   <a class="link" href="create-function-loadable.html" title="15.7.4.1 CREATE FUNCTION Statement for Loadable Functions">
    <code class="literal">
     CREATE
      FUNCTION
    </code>
   </a>
   as well as loadable functions installed
      automatically by components or plugins. This difference makes
   <a class="link" href="performance-schema-user-defined-functions-table.html" title="29.12.22.10 The user_defined_functions Table">
    <code class="literal">
     user_defined_functions
    </code>
   </a>
   preferable to
   <code class="literal">
    mysql.func
   </code>
   for checking which loadable
      functions are installed. See
   <a class="xref" href="performance-schema-user-defined-functions-table.html" title="29.12.22.10 The user_defined_functions Table">
    Section 29.12.22.10, “The user_defined_functions Table”
   </a>
   .
  </p>
 </div>
 <br/>
</div>
