<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="trigger-metadata">
      </a>
      27.3.2 Trigger Metadata
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045082279760">
  </a>
  <a class="indexterm" name="idm46045082278272">
  </a>
  <p>
   To obtain metadata about triggers:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      Query the
      <a class="link" href="information-schema-triggers-table.html" title="28.3.44 The INFORMATION_SCHEMA TRIGGERS Table">
       <code class="literal">
        TRIGGERS
       </code>
      </a>
      table of the
      <code class="literal">
       INFORMATION_SCHEMA
      </code>
      database. See
      <a class="xref" href="information-schema-triggers-table.html" title="28.3.44 The INFORMATION_SCHEMA TRIGGERS Table">
       Section 28.3.44, “The INFORMATION_SCHEMA TRIGGERS Table”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Use the
      <a class="link" href="show-create-trigger.html" title="15.7.7.12 SHOW CREATE TRIGGER Statement">
       <code class="literal">
        SHOW CREATE TRIGGER
       </code>
      </a>
      statement. See
      <a class="xref" href="show-create-trigger.html" title="15.7.7.12 SHOW CREATE TRIGGER Statement">
       Section 15.7.7.12, “SHOW CREATE TRIGGER Statement”
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      Use the
      <a class="link" href="show-triggers.html" title="15.7.7.40 SHOW TRIGGERS Statement">
       <code class="literal">
        SHOW TRIGGERS
       </code>
      </a>
      statement. See
      <a class="xref" href="show-triggers.html" title="15.7.7.40 SHOW TRIGGERS Statement">
       Section 15.7.7.40, “SHOW TRIGGERS Statement”
      </a>
      .
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
