<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="stored-routines-metadata">
      </a>
      27.2.3 Stored Routine Metadata
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045082465264">
  </a>
  <a class="indexterm" name="idm46045082463776">
  </a>
  <p>
   To obtain metadata about stored routines:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Query the
      <a class="link" href="information-schema-routines-table.html" title="28.3.30 The INFORMATION_SCHEMA ROUTINES Table">
       <code class="literal">
        ROUTINES
       </code>
      </a>
      table of the
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      database. See
      <a class="xref" href="information-schema-routines-table.html" title="28.3.30 The INFORMATION_SCHEMA ROUTINES Table">
       Section 28.3.30, “The INFORMATION_SCHEMA ROUTINES Table”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Use the
      <a class="link" href="show-create-procedure.html" title="15.7.7.10 SHOW CREATE PROCEDURE Statement">
       <code class="literal">
        SHOW CREATE PROCEDURE
       </code>
      </a>
      and
      <a class="link" href="show-create-function.html" title="15.7.7.9 SHOW CREATE FUNCTION Statement">
       <code class="literal">
        SHOW CREATE FUNCTION
       </code>
      </a>
      statements to see routine definitions. See
      <a class="xref" href="show-create-procedure.html" title="15.7.7.10 SHOW CREATE PROCEDURE Statement">
       Section 15.7.7.10, “SHOW CREATE PROCEDURE Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Use the
      <a class="link" href="show-procedure-status.html" title="15.7.7.30 SHOW PROCEDURE STATUS Statement">
       <code class="literal">
        SHOW PROCEDURE STATUS
       </code>
      </a>
      and
      <a class="link" href="show-function-status.html" title="15.7.7.21 SHOW FUNCTION STATUS Statement">
       <code class="literal">
        SHOW FUNCTION STATUS
       </code>
      </a>
      statements to see routine characteristics. See
      <a class="xref" href="show-procedure-status.html" title="15.7.7.30 SHOW PROCEDURE STATUS Statement">
       Section 15.7.7.30, “SHOW PROCEDURE STATUS Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Use the
      <a class="link" href="show-procedure-code.html" title="15.7.7.29 SHOW PROCEDURE CODE Statement">
       <code class="literal">
        SHOW PROCEDURE CODE
       </code>
      </a>
      and
      <a class="link" href="show-function-code.html" title="15.7.7.20 SHOW FUNCTION CODE Statement">
       <code class="literal">
        SHOW FUNCTION CODE
       </code>
      </a>
      statements
          to see a representation of the internal implementation of the
          routine. See
      <a class="xref" href="show-procedure-code.html" title="15.7.7.29 SHOW PROCEDURE CODE Statement">
       Section 15.7.7.29, “SHOW PROCEDURE CODE Statement”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
