<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="drop-trigger">
      </a>
      15.1.34 DROP TRIGGER Statement
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045183240496">
  </a>
  <a class="indexterm" name="idm46045183239424">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa57097968"><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">DROP</span> <span class="token keyword">TRIGGER</span> <span class="token punctuation">[</span><span class="token keyword">IF</span> <span class="token keyword">EXISTS</span><span class="token punctuation">]</span> <span class="token punctuation">[</span><span class="token keyword"><em class="replaceable">schema_name</em></span><span class="token punctuation">.</span><span class="token punctuation">]</span><em class="replaceable">trigger_name</em></code></pre>
  </div>
  <p>
   This statement drops a trigger. The schema (database) name is
      optional. If the schema is omitted, the trigger is dropped from
      the default schema.
   <a class="link" href="drop-trigger.html" title="15.1.34 DROP TRIGGER Statement">
    <code class="literal">
     DROP TRIGGER
    </code>
   </a>
   requires the
   <a class="link" href="privileges-provided.html#priv_trigger">
    <code class="literal">
     TRIGGER
    </code>
   </a>
   privilege for
      the table associated with the trigger.
  </p>
  <p>
   Use
   <code class="literal">
    IF EXISTS
   </code>
   to prevent an error from
      occurring for a trigger that does not exist. A
   <code class="literal">
    NOTE
   </code>
   is generated for a nonexistent trigger
      when using
   <code class="literal">
    IF EXISTS
   </code>
   . See
   <a class="xref" href="show-warnings.html" title="15.7.7.42 SHOW WARNINGS Statement">
    Section 15.7.7.42, “SHOW WARNINGS Statement”
   </a>
   .
  </p>
  <p>
   Triggers for a table are also dropped if you drop the table.
  </p>
 </div>
 <br/>
</div>
