<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="mysql-cluster-programs-ndb-drop-index">
      </a>
      25.5.10 ndb_drop_index — Drop Index from an NDB Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045103876432">
  </a>
  <p>
   <a class="link" href="mysql-cluster-programs-ndb-drop-index.html" title="25.5.10 ndb_drop_index — Drop Index from an NDB Table">
    <span class="command">
     <strong>
      ndb_drop_index
     </strong>
    </span>
   </a>
   drops the specified index from
        an
   <a class="link" href="mysql-cluster.html" title="Chapter 25 MySQL NDB Cluster 8.4">
    <code class="literal">
     NDB
    </code>
   </a>
   table.
   <span class="emphasis">
    <em>
     It is
        recommended that you use this utility only as an example for
        writing NDB API applications
    </em>
   </span>
   —see the Warning
        later in this section for details.
  </p>
  <h4>
   <a name="idm46045103871872">
   </a>
   Usage
  </h4>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting one-line language-terminal"><div class="docs-select-all right" id="sa83583439"><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-terminal">ndb_drop_index <span class="token property">-c</span> <em class="replaceable">connection_string</em> <em class="replaceable">table_name</em> <em class="replaceable">index</em> <span class="token property">-d</span> <em class="replaceable">db_name</em></code></pre>
  </div>
  <p>
   The statement shown above drops the index named
   <em class="replaceable">
    <code>
     index
    </code>
   </em>
   from the
   <em class="replaceable">
    <code>
     table
    </code>
   </em>
   in the
   <em class="replaceable">
    <code>
     database
    </code>
   </em>
   .
  </p>
  <p>
   Options that can be used with
   <a class="link" href="mysql-cluster-programs-ndb-drop-index.html" title="25.5.10 ndb_drop_index — Drop Index from an NDB Table">
    <span class="command">
     <strong>
      ndb_drop_index
     </strong>
    </span>
   </a>
   are shown in the following table. Additional descriptions follow
        the table.
  </p>
  <p>
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_character-sets-dir">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_character-sets-dir">
       <code class="option">
        --character-sets-dir
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103861760">
     </a>
     <a class="indexterm" name="idm46045103860256">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for character-sets-dir">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --character-sets-dir=path
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Directory containing character sets.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_connect-retries">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_connect-retries">
       <code class="option">
        --connect-retries
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103850400">
     </a>
     <a class="indexterm" name="idm46045103848912">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retries">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retries=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           12
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           12
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of times to retry connection before giving up.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_connect-retry-delay">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_connect-retry-delay">
       <code class="option">
        --connect-retry-delay
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103829808">
     </a>
     <a class="indexterm" name="idm46045103828304">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-retry-delay">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-retry-delay=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           5
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Minimum Value
         </th>
         <td>
          <code class="literal">
           0
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Maximum Value
         </th>
         <td>
          <code class="literal">
           5
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Number of seconds to wait between attempts to contact
            management server.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_connect-string">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_connect-string">
       <code class="option">
        --connect-string
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103809248">
     </a>
     <a class="indexterm" name="idm46045103807760">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for connect-string">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --connect-string=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_core-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_core-file">
       <code class="option">
        --core-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103792400">
     </a>
     <a class="indexterm" name="idm46045103790912">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for core-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --core-file
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Write core file on error; used in debugging.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_database">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_database">
       <code class="option">
        --database
       </code>
      </a>
      ,
      <code class="option">
       -d
      </code>
     </p>
     <a class="indexterm" name="idm46045103780720">
     </a>
     <a class="indexterm" name="idm46045103779232">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for database">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --database=name
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           TEST_DB
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Name of the database in which the table resides.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_defaults-extra-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_defaults-extra-file">
       <code class="option">
        --defaults-extra-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103764944">
     </a>
     <a class="indexterm" name="idm46045103763440">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-extra-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-extra-file=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read given file after global files are read.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_defaults-file">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_defaults-file">
       <code class="option">
        --defaults-file
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103749216">
     </a>
     <a class="indexterm" name="idm46045103747728">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-file">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-file=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read default options from given file only.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_defaults-group-suffix">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_defaults-group-suffix">
       <code class="option">
        --defaults-group-suffix
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103733312">
     </a>
     <a class="indexterm" name="idm46045103731808">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for defaults-group-suffix">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --defaults-group-suffix=string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Also read groups with concat(group, suffix).
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_help">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_help">
       <code class="option">
        --help
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103717520">
     </a>
     <a class="indexterm" name="idm46045103716032">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for help">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --help
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display help text and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_login-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_login-path">
       <code class="option">
        --login-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103706352">
     </a>
     <a class="indexterm" name="idm46045103704864">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for login-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --login-path=path
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Read given path from login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_no-login-paths">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_no-login-paths">
       <code class="option">
        --no-login-paths
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103690592">
     </a>
     <a class="indexterm" name="idm46045103689104">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-login-paths">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-login-paths
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Skips reading options from the login path file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_ndb-connectstring">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103679440">
     </a>
     <a class="indexterm" name="idm46045103677984">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-connectstring">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-connectstring=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set connection string for connecting to
      <a class="link" href="mysql-cluster-programs-ndb-mgmd.html" title="25.5.4 ndb_mgmd — The NDB Cluster Management Server Daemon">
       <span class="command">
        <strong>
         ndb_mgmd
        </strong>
       </span>
      </a>
      . Syntax:
      <code class="literal">
       [nodeid=
       <em class="replaceable">
        <code>
         id
        </code>
       </em>
       ;][host=]
       <em class="replaceable">
        <code>
         hostname
        </code>
       </em>
       [:
       <em class="replaceable">
        <code>
         port
        </code>
       </em>
       ]
      </code>
      .
            Overrides entries in
      <code class="literal">
       NDB_CONNECTSTRING
      </code>
      and
      <code class="filename">
       my.cnf
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_ndb-mgm-tls">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-mgm-tls">
       <code class="option">
        --ndb-mgm-tls
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103658880">
     </a>
     <a class="indexterm" name="idm46045103657392">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgm-tls">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgm-tls=level
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Enumeration
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           relaxed
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Valid Values
         </th>
         <td>
          <p class="valid-value">
           <code class="literal">
            relaxed
           </code>
          </p>
          <p class="valid-value">
           <code class="literal">
            strict
           </code>
          </p>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Sets the level of TLS support required to connect to the
            management server; one of
      <code class="literal">
       relaxed
      </code>
      or
      <code class="literal">
       strict
      </code>
      .
      <code class="literal">
       relaxed
      </code>
      (the
            default) means that a TLS connection is attempted, but
            success is not required;
      <code class="literal">
       strict
      </code>
      means
            that TLS is required to connect.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_ndb-mgmd-host">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-mgmd-host">
       <code class="option">
        --ndb-mgmd-host
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103636272">
     </a>
     <a class="indexterm" name="idm46045103634784">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-mgmd-host">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-mgmd-host=connection_string
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          String
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Same as
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_ndb-nodeid">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-nodeid">
       <code class="option">
        --ndb-nodeid
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103619600">
     </a>
     <a class="indexterm" name="idm46045103618112">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-nodeid">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-nodeid=#
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Integer
         </td>
        </tr>
        <tr>
         <th>
          Default Value
         </th>
         <td>
          <code class="literal">
           [none]
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Set node ID for this node, overriding any ID set by
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-connectstring">
       <code class="option">
        --ndb-connectstring
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_ndb-optimized-node-selection">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-optimized-node-selection">
       <code class="option">
        --ndb-optimized-node-selection
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103602736">
     </a>
     <a class="indexterm" name="idm46045103601232">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-optimized-node-selection">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-optimized-node-selection
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Enable optimizations for selection of nodes for
            transactions. Enabled by default; use
      <code class="option">
       --skip-ndb-optimized-node-selection
      </code>
      to
            disable.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_ndb-tls-search-path">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_ndb-tls-search-path">
       <code class="option">
        --ndb-tls-search-path
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103590864">
     </a>
     <a class="indexterm" name="idm46045103589360">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for ndb-tls-search-path">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --ndb-tls-search-path=list
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Type
         </th>
         <td>
          Path name
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Unix)
         </th>
         <td>
          <code class="literal">
           $HOME/ndb-tls
          </code>
         </td>
        </tr>
        <tr>
         <th>
          Default Value (Windows)
         </th>
         <td>
          <code class="literal">
           $HOMEDIR/ndb-tls
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Specify a list of directories to search for a CA file. On
            Unix platforms, the directory names are separated by colons
            (
      <code class="literal">
       :
      </code>
      ); on Windows systems, the semicolon
            character (
      <code class="literal">
       ;
      </code>
      ) is used as the separator. A
            directory reference may be relative or absolute; it may
            contain one or more environment variables, each denoted by a
            prefixed dollar sign (
      <code class="literal">
       $
      </code>
      ), and expanded
            prior to use.
     </p>
     <p>
      Searching begins with the leftmost named directory and
            proceeds from left to right until a file is found. An empty
            string denotes an empty search path, which causes all
            searches to fail. A string consisting of a single dot
            (
      <code class="literal">
       .
      </code>
      ) indicates that the search path
            limited to the current working directory.
     </p>
     <p>
      If no search path is supplied, the compiled-in default value
            is used. This value depends on the platform used: On
            Windows, this is
      <code class="literal">
       \ndb-tls
      </code>
      ; on other
            platforms (including Linux), it is
      <code class="literal">
       $HOME/ndb-tls
      </code>
      . This can be overridden by
            compiling NDB Cluster using
      <a class="link" href="source-configuration-options.html#option_cmake_with_ndb_tls_search_path">
       <code class="option">
        -DWITH_NDB_TLS_SEARCH_PATH
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_no-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_no-defaults">
       <code class="option">
        --no-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103565664">
     </a>
     <a class="indexterm" name="idm46045103564176">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for no-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --no-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Do not read default options from any option file other than
            login file.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_print-defaults">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_print-defaults">
       <code class="option">
        --print-defaults
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103554288">
     </a>
     <a class="indexterm" name="idm46045103552800">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for print-defaults">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --print-defaults
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Print program argument list and exit.
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_usage">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_usage">
       <code class="option">
        --usage
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103543088">
     </a>
     <a class="indexterm" name="idm46045103541600">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for usage">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --usage
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display help text and exit; same as
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_help">
       <code class="option">
        --help
       </code>
      </a>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <a name="option_ndb_drop_index_version">
      </a>
      <a class="link" href="mysql-cluster-programs-ndb-drop-index.html#option_ndb_drop_index_version">
       <code class="option">
        --version
       </code>
      </a>
     </p>
     <a class="indexterm" name="idm46045103530912">
     </a>
     <a class="indexterm" name="idm46045103529424">
     </a>
     <div class="informaltable">
      <table frame="box" rules="all" summary="Properties for version">
       <colgroup>
        <col style="width: 30%"/>
        <col style="width: 70%"/>
       </colgroup>
       <tbody>
        <tr>
         <th>
          Command-Line Format
         </th>
         <td>
          <code class="literal">
           --version
          </code>
         </td>
        </tr>
       </tbody>
      </table>
     </div>
     <p>
      Display version information and exit.
     </p>
    </li>
   </ul>
  </div>
  <div class="warning" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Warning
   </div>
   <p>
    <span class="emphasis">
     <em>
      Operations performed on Cluster table indexes using
          the NDB API are not visible to MySQL and make the table
          unusable by a MySQL server
     </em>
    </span>
    . If you use this program
          to drop an index, then try to access the table from an SQL
          node, an error results, as shown here:
   </p>
  </div>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-terminal"><div class="docs-select-all right" id="sa9263973"><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-terminal"><span class="token prompt">$&gt; </span><span class="token command">./ndb_drop_index</span> <span class="token property">-c</span> localhost dogs ix <span class="token property">-d</span> ctest1
Dropping index dogs/idx<span class="token punctuation">.</span><span class="token punctuation">.</span><span class="token punctuation">.</span>OK

<span class="token prompt">$&gt; </span><span class="token command">./mysql</span> <span class="token property">-u</span> jon <span class="token property">-p</span> ctest1
Enter password<span class="token punctuation">:</span> *******
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with <span class="token property">-A</span>

Welcome to the MySQL monitor<span class="token punctuation">.</span>  Commands end with <span class="token punctuation">;</span> or \g<span class="token punctuation">.</span>
Your MySQL connection id is 7 to server version<span class="token punctuation">:</span> 5<span class="token punctuation">.</span>7<span class="token punctuation">.</span>44-ndb-7<span class="token punctuation">.</span>5<span class="token punctuation">.</span>36

Type <span class="token atrule">'help;'</span> or <span class="token atrule">'\h'</span> for help<span class="token punctuation">.</span> Type <span class="token atrule">'\c'</span> to clear the buffer<span class="token punctuation">.</span>

<span class="token prompt">mysql&gt;</span><span class="token command"> SHOW</span> TABLES<span class="token punctuation">;</span>
<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>
<span class="token output"><span class="token punctuation">|</span> Tables_in_ctest1 <span class="token punctuation">|</span></span>
<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>
<span class="token output"><span class="token punctuation">|</span> a                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> bt1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> bt2              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> dogs             <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> employees        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> fish             <span class="token punctuation">|</span></span>
<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>
<span class="token output">6 rows in set (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span><span class="token command"> SELECT</span> * FROM dogs<span class="token punctuation">;</span>
<span class="token output">ERROR 1296 (HY000)<span class="token punctuation">:</span> Got error 4243 'Index not found' from NDBCLUSTER</span></code></pre>
  </div>
  <p>
   In such a case, your
   <span class="emphasis">
    <em>
     only
    </em>
   </span>
   option for making
        the table available to MySQL again is to drop the table and
        re-create it. You can use either the SQL
        statement
   <a class="link" href="drop-table.html" title="15.1.32 DROP TABLE Statement">
    <code class="literal">
     DROP TABLE
    </code>
   </a>
   or the
   <a class="link" href="mysql-cluster-programs-ndb-drop-table.html" title="25.5.11 ndb_drop_table — Drop an NDB Table">
    <span class="command">
     <strong>
      ndb_drop_table
     </strong>
    </span>
   </a>
   utility (see
   <a class="xref" href="mysql-cluster-programs-ndb-drop-table.html" title="25.5.11 ndb_drop_table — Drop an NDB Table">
    Section 25.5.11, “ndb_drop_table — Drop an NDB Table”
   </a>
   ) to drop
        the table.
  </p>
 </div>
 <br/>
</div>
