<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-index-columns">
      </a>
      25.6.17.40 The ndbinfo index_columns Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089129056">
  </a>
  <p>
   This table provides information about indexes on
   <code class="literal">
    NDB
   </code>
   tables. The columns of the
   <code class="literal">
    index_columns
   </code>
   table are listed here, along
        with brief descriptions:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       table_id
      </code>
     </p>
     <p>
      Unique ID of the
      <code class="literal">
       NDB
      </code>
      table for which the
            index is defined
     </p>
    </li>
    <li class="listitem">
     <p>
      Name of the database containing this table
     </p>
     <p>
      <code class="literal">
       varchar(64)
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_name
      </code>
     </p>
     <p>
      Name of the table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       index_object_id
      </code>
     </p>
     <p>
      Object ID of this index
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       index_name
      </code>
     </p>
     <p>
      Name of the index; if the index is not named, the name of
            the first column in the index is used
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       index_type
      </code>
     </p>
     <p>
      Type of index; normally this is 3 (unique hash index) or 6
            (ordered index); the values are the same as those in the
      <code class="literal">
       type_id
      </code>
      column of the
      <a class="link" href="mysql-cluster-ndbinfo-dict-obj-types.html" title="25.6.17.27 The ndbinfo dict_obj_types Table">
       <code class="literal">
        dict_obj_types
       </code>
      </a>
      table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       status
      </code>
     </p>
     <p>
      One of
      <code class="literal">
       new
      </code>
      ,
      <code class="literal">
       changed
      </code>
      ,
      <code class="literal">
       retrieved
      </code>
      ,
      <code class="literal">
       invalid
      </code>
      , or
      <code class="literal">
       altered
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       columns
      </code>
     </p>
     <p>
      A comma-delimited list of columns making up the index
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
