<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="show-procedure-status">
      </a>
      15.7.7.30 SHOW PROCEDURE STATUS Statement
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045169953648">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa34616638"><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">SHOW</span> <span class="token keyword">PROCEDURE</span> <span class="token keyword">STATUS</span>
    <span class="token punctuation">[</span><span class="token operator">LIKE</span> <span class="token string">'<em class="replaceable">pattern</em>'</span> <span class="token operator">|</span> <span class="token keyword">WHERE</span> <em class="replaceable">expr</em><span class="token punctuation">]</span></code></pre>
  </div>
  <p>
   This statement is a MySQL extension. It returns characteristics
        of a stored procedure, such as the database, name, type,
        creator, creation and modification dates, and character set
        information. A similar statement,
   <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>
   , displays information about stored
        functions (see
   <a class="xref" href="show-function-status.html" title="15.7.7.21 SHOW FUNCTION STATUS Statement">
    Section 15.7.7.21, “SHOW FUNCTION STATUS Statement”
   </a>
   ).
  </p>
  <p>
   To use either statement, you must be the user named as the
        routine
   <code class="literal">
    DEFINER
   </code>
   , have the
   <a class="link" href="privileges-provided.html#priv_show-routine">
    <code class="literal">
     SHOW_ROUTINE
    </code>
   </a>
   privilege, have the
   <a class="link" href="privileges-provided.html#priv_select">
    <code class="literal">
     SELECT
    </code>
   </a>
   privilege at the global
        level, or have the
   <a class="link" href="privileges-provided.html#priv_create-routine">
    <code class="literal">
     CREATE
        ROUTINE
    </code>
   </a>
   ,
   <a class="link" href="privileges-provided.html#priv_alter-routine">
    <code class="literal">
     ALTER ROUTINE
    </code>
   </a>
   ,
        or
   <a class="link" href="privileges-provided.html#priv_execute">
    <code class="literal">
     EXECUTE
    </code>
   </a>
   privilege granted at a
        scope that includes the routine.
  </p>
  <p>
   The
   <a class="link" href="string-comparison-functions.html#operator_like">
    <code class="literal">
     LIKE
    </code>
   </a>
   clause, if present,
        indicates which procedure or function names to match. The
   <code class="literal">
    WHERE
   </code>
   clause can be given to select rows
        using more general conditions, as discussed in
   <a class="xref" href="extended-show.html" title="28.8 Extensions to SHOW Statements">
    Section 28.8, “Extensions to SHOW Statements”
   </a>
   .
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa16724578"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">PROCEDURE</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'sp1'</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
                  Db<span class="token punctuation">:</span> test
                Name<span class="token punctuation">:</span> sp1
                Type<span class="token punctuation">:</span> PROCEDURE
             Definer<span class="token punctuation">:</span> testuser@localhost
            Modified<span class="token punctuation">:</span> 2018-08-08 13<span class="token punctuation">:</span>54<span class="token punctuation">:</span>11
             Created<span class="token punctuation">:</span> 2018-08-08 13<span class="token punctuation">:</span>54<span class="token punctuation">:</span>11
       Security_type<span class="token punctuation">:</span> DEFINER
             Comment<span class="token punctuation">:</span>
character_set_client<span class="token punctuation">:</span> utf8mb4
collation_connection<span class="token punctuation">:</span> utf8mb4_0900_ai_ci
  Database Collation<span class="token punctuation">:</span> utf8mb4_0900_ai_ci
</span>
<span class="token prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">FUNCTION</span> <span class="token keyword">STATUS</span> <span class="token operator">LIKE</span> <span class="token string">'hello'</span>\G
<span class="token output"><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span> 1. row <span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span><span class="token punctuation">*</span>
                  Db<span class="token punctuation">:</span> test
                Name<span class="token punctuation">:</span> hello
                Type<span class="token punctuation">:</span> FUNCTION
             Definer<span class="token punctuation">:</span> testuser@localhost
            Modified<span class="token punctuation">:</span> 2020-03-10 11<span class="token punctuation">:</span>10<span class="token punctuation">:</span>03
             Created<span class="token punctuation">:</span> 2020-03-10 11<span class="token punctuation">:</span>10<span class="token punctuation">:</span>03
       Security_type<span class="token punctuation">:</span> DEFINER
             Comment<span class="token punctuation">:</span>
character_set_client<span class="token punctuation">:</span> utf8mb4
collation_connection<span class="token punctuation">:</span> utf8mb4_0900_ai_ci
  Database Collation<span class="token punctuation">:</span> utf8mb4_0900_ai_ci</span></code></pre>
  </div>
  <p>
   <code class="literal">
    character_set_client
   </code>
   is the session value of
        the
   <a class="link" href="server-system-variables.html#sysvar_character_set_client">
    <code class="literal">
     character_set_client
    </code>
   </a>
   system
        variable when the routine was created.
   <code class="literal">
    collation_connection
   </code>
   is the session value of
        the
   <a class="link" href="server-system-variables.html#sysvar_collation_connection">
    <code class="literal">
     collation_connection
    </code>
   </a>
   system
        variable when the routine was created.
   <code class="literal">
    Database
        Collation
   </code>
   is the collation of the database with which
        the routine is associated.
  </p>
  <p>
   Stored routine information is also available from the
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   <a class="link" href="information-schema-parameters-table.html" title="28.3.20 The INFORMATION_SCHEMA PARAMETERS Table">
    <code class="literal">
     PARAMETERS
    </code>
   </a>
   and
   <a class="link" href="information-schema-routines-table.html" title="28.3.30 The INFORMATION_SCHEMA ROUTINES Table">
    <code class="literal">
     ROUTINES
    </code>
   </a>
   tables. See
   <a class="xref" href="information-schema-parameters-table.html" title="28.3.20 The INFORMATION_SCHEMA PARAMETERS Table">
    Section 28.3.20, “The INFORMATION_SCHEMA PARAMETERS Table”
   </a>
   , and
   <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>
 </div>
 <br/>
</div>
