<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="drop-event">
      </a>
      15.1.25 DROP EVENT Statement
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045183471424">
  </a>
  <a class="indexterm" name="idm46045183470352">
  </a>
  <a class="indexterm" name="idm46045183468864">
  </a>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-sql"><div class="docs-select-all right" id="sa75626466"><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">EVENT</span> <span class="token punctuation">[</span><span class="token keyword">IF</span> <span class="token keyword">EXISTS</span><span class="token punctuation">]</span> <em class="replaceable">event_name</em></code></pre>
  </div>
  <p>
   This statement drops the event named
   <em class="replaceable">
    <code>
     event_name
    </code>
   </em>
   . The event immediately
      ceases being active, and is deleted completely from the server.
  </p>
  <p>
   If the event does not exist, the error
   <span class="errortext">
    ERROR 1517
      (HY000): Unknown event
      '
    <em class="replaceable">
     <code>
      event_name
     </code>
    </em>
    '
   </span>
   results. You
      can override this and cause the statement to generate a warning
      for nonexistent events instead using
   <code class="literal">
    IF EXISTS
   </code>
   .
  </p>
  <p>
   This statement requires the
   <a class="link" href="privileges-provided.html#priv_event">
    <code class="literal">
     EVENT
    </code>
   </a>
   privilege for the schema to which the event to be dropped belongs.
  </p>
 </div>
 <br/>
</div>
