<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-dict-obj-info">
      </a>
      25.6.17.25 The ndbinfo dict_obj_info Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089672720">
  </a>
  <p>
   The
   <code class="literal">
    dict_obj_info
   </code>
   table provides information
        about
   <code class="literal">
    NDB
   </code>
   data dictionary
        (
   <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-kernel-blocks-dbdict.html" target="_top">
    <code class="literal">
     DICT
    </code>
   </a>
   ) objects such as
        tables and indexes. (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 can be
        queried for a list of all the types.) This information includes
        the object's type, state, parent object (if any), and fully
        qualified name.
  </p>
  <p>
   The
   <code class="literal">
    dict_obj_info
   </code>
   table contains the
        following columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       type
      </code>
     </p>
     <p>
      Type of
      <a class="ulink" href="/doc/ndb-internals/en/ndb-internals-kernel-blocks-dbdict.html" target="_top">
       <code class="literal">
        DICT
       </code>
      </a>
      object;
            join on
      <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>
      to
            obtain the name
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       id
      </code>
     </p>
     <p>
      Object identifier; for Disk Data undo log files and data
            files, this is the same as the value shown in the
      <code class="literal">
       LOGFILE_GROUP_NUMBER
      </code>
      column of the
            Information Schema
      <a class="link" href="information-schema-files-table.html" title="28.3.15 The INFORMATION_SCHEMA FILES Table">
       <code class="literal">
        FILES
       </code>
      </a>
      table;
            for undo log files, it also the same as the value shown for
            the
      <code class="literal">
       log_id
      </code>
      column in the
      <code class="literal">
       ndbinfo
      </code>
      <a class="link" href="mysql-cluster-ndbinfo-logbuffers.html" title="25.6.17.43 The ndbinfo logbuffers Table">
       <code class="literal">
        logbuffers
       </code>
      </a>
      and
      <a class="link" href="mysql-cluster-ndbinfo-logspaces.html" title="25.6.17.44 The ndbinfo logspaces Table">
       <code class="literal">
        logspaces
       </code>
      </a>
      tables
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       version
      </code>
     </p>
     <p>
      Object version
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       state
      </code>
     </p>
     <p>
      Object state; see
      <a class="ulink" href="/doc/ndbapi/en/ndb-object.html#ndb-object-state" target="_top">
       Object::State
      </a>
      for
            values and descriptions.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_obj_type
      </code>
     </p>
     <p>
      Parent object's type (a
      <code class="literal">
       dict_obj_types
      </code>
      type ID); 0 indicates that
            the object has no parent
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_obj_id
      </code>
     </p>
     <p>
      Parent object ID (such as a base table); 0 indicates that
            the object has no parent
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       fq_name
      </code>
     </p>
     <p>
      Fully qualified object name; for a table, this has the form
      <code class="literal">
       <em class="replaceable">
        <code>
         database_name
        </code>
       </em>
       /def/
       <em class="replaceable">
        <code>
         table_name
        </code>
       </em>
      </code>
      ,
            for a primary key, the form is
      <code class="literal">
       sys/def/
       <em class="replaceable">
        <code>
         table_id
        </code>
       </em>
       /PRIMARY
      </code>
      ,
            and for a unique key it is
      <code class="literal">
       sys/def/
       <em class="replaceable">
        <code>
         table_id
        </code>
       </em>
       /
       <em class="replaceable">
        <code>
         uk_name
        </code>
       </em>
       $unique
      </code>
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
