<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="replication-features-drop-if-exists">
      </a>
      19.5.1.11 Replication of DROP ... IF EXISTS Statements
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045135638944">
  </a>
  <a class="indexterm" name="idm46045135637456">
  </a>
  <p>
   The
   <a class="link" href="drop-database.html" title="15.1.24 DROP DATABASE Statement">
    <code class="literal">
     DROP DATABASE
        IF EXISTS
    </code>
   </a>
   ,
   <a class="link" href="drop-table.html" title="15.1.32 DROP TABLE Statement">
    <code class="literal">
     DROP TABLE IF
        EXISTS
    </code>
   </a>
   , and
   <a class="link" href="drop-view.html" title="15.1.35 DROP VIEW Statement">
    <code class="literal">
     DROP VIEW IF
        EXISTS
    </code>
   </a>
   statements are always replicated, even if the
        database, table, or view to be dropped does not exist on the
        source. This is to ensure that the object to be dropped no
        longer exists on either the source or the replica, once the
        replica has caught up with the source.
  </p>
  <p>
   <code class="literal">
    DROP ... IF EXISTS
   </code>
   statements for stored
        programs (stored procedures and functions, triggers, and events)
        are also replicated, even if the stored program to be dropped
        does not exist on the source.
  </p>
 </div>
 <br/>
</div>
