<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-parameters-table">
      </a>
      28.3.20 The INFORMATION_SCHEMA PARAMETERS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045079440640">
  </a>
  <p>
   The
   <a class="link" href="information-schema-parameters-table.html" title="28.3.20 The INFORMATION_SCHEMA PARAMETERS Table">
    <code class="literal">
     PARAMETERS
    </code>
   </a>
   table provides
      information about parameters for stored routines (stored
      procedures and stored functions), and about return values for
      stored functions. The
   <a class="link" href="information-schema-parameters-table.html" title="28.3.20 The INFORMATION_SCHEMA PARAMETERS Table">
    <code class="literal">
     PARAMETERS
    </code>
   </a>
   table does not include built-in (native) functions or loadable
      functions.
  </p>
  <p>
   The
   <a class="link" href="information-schema-parameters-table.html" title="28.3.20 The INFORMATION_SCHEMA PARAMETERS Table">
    <code class="literal">
     PARAMETERS
    </code>
   </a>
   table has these
      columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       SPECIFIC_CATALOG
      </code>
     </p>
     <p>
      The name of the catalog to which the routine containing the
          parameter belongs. This value is always
      <code class="literal">
       def
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SPECIFIC_SCHEMA
      </code>
     </p>
     <p>
      The name of the schema (database) to which the routine
          containing the parameter belongs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       SPECIFIC_NAME
      </code>
     </p>
     <p>
      The name of the routine containing the parameter.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ORDINAL_POSITION
      </code>
     </p>
     <p>
      For successive parameters of a stored procedure or function,
          the
      <code class="literal">
       ORDINAL_POSITION
      </code>
      values are 1, 2, 3,
          and so forth. For a stored function, there is also a row that
          applies to the function return value (as described by the
      <code class="literal">
       RETURNS
      </code>
      clause). The return value is not a
          true parameter, so the row that describes it has these unique
          characteristics:
     </p>
     <div class="itemizedlist">
      <ul class="itemizedlist" style="list-style-type: circle; ">
       <li class="listitem">
        <p>
         The
         <code class="literal">
          ORDINAL_POSITION
         </code>
         value is 0.
        </p>
       </li>
       <li class="listitem">
        <p>
         The
         <code class="literal">
          PARAMETER_NAME
         </code>
         and
         <code class="literal">
          PARAMETER_MODE
         </code>
         values are
         <code class="literal">
          NULL
         </code>
         because the return value has no
              name and the mode does not apply.
        </p>
       </li>
      </ul>
     </div>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PARAMETER_MODE
      </code>
     </p>
     <p>
      The mode of the parameter. This value is one of
      <code class="literal">
       IN
      </code>
      ,
      <code class="literal">
       OUT
      </code>
      , or
      <code class="literal">
       INOUT
      </code>
      . For a stored function return value,
          this value is
      <code class="literal">
       NULL
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       PARAMETER_NAME
      </code>
     </p>
     <p>
      The name of the parameter. For a stored function return value,
          this value is
      <code class="literal">
       NULL
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DATA_TYPE
      </code>
     </p>
     <p>
      The parameter data type.
     </p>
     <p>
      The
      <code class="literal">
       DATA_TYPE
      </code>
      value is the type name only
          with no other information. The
      <code class="literal">
       DTD_IDENTIFIER
      </code>
      value contains the type name
          and possibly other information such as the precision or
          length.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CHARACTER_MAXIMUM_LENGTH
      </code>
     </p>
     <p>
      For string parameters, the maximum length in characters.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CHARACTER_OCTET_LENGTH
      </code>
     </p>
     <p>
      For string parameters, the maximum length in bytes.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NUMERIC_PRECISION
      </code>
     </p>
     <p>
      For numeric parameters, the numeric precision.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       NUMERIC_SCALE
      </code>
     </p>
     <p>
      For numeric parameters, the numeric scale.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DATETIME_PRECISION
      </code>
     </p>
     <p>
      For temporal parameters, the fractional seconds precision.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CHARACTER_SET_NAME
      </code>
     </p>
     <p>
      For character string parameters, the character set name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       COLLATION_NAME
      </code>
     </p>
     <p>
      For character string parameters, the collation name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       DTD_IDENTIFIER
      </code>
     </p>
     <p>
      The parameter data type.
     </p>
     <p>
      The
      <code class="literal">
       DATA_TYPE
      </code>
      value is the type name only
          with no other information. The
      <code class="literal">
       DTD_IDENTIFIER
      </code>
      value contains the type name
          and possibly other information such as the precision or
          length.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       ROUTINE_TYPE
      </code>
     </p>
     <p>
      <code class="literal">
       PROCEDURE
      </code>
      for stored procedures,
      <code class="literal">
       FUNCTION
      </code>
      for stored functions.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
