<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-dict-obj-tree">
      </a>
      25.6.17.26 The ndbinfo dict_obj_tree Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089635888">
  </a>
  <p>
   The
   <code class="literal">
    dict_obj_tree
   </code>
   table provides a tree-based
        view of table information from the
   <a class="link" href="mysql-cluster-ndbinfo-dict-obj-info.html" title="25.6.17.25 The ndbinfo dict_obj_info Table">
    <code class="literal">
     dict_obj_info
    </code>
   </a>
   table. This is
        intended primarily for use in testing, but can be useful in
        visualizing hierarchies of
   <code class="literal">
    NDB
   </code>
   database
        objects.
  </p>
  <p>
   The
   <code class="literal">
    dict_obj_tree
   </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 of the object type
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       id
      </code>
     </p>
     <p>
      Object identifier; same as the
      <code class="literal">
       id
      </code>
      column
            in
      <a class="link" href="mysql-cluster-ndbinfo-dict-obj-info.html" title="25.6.17.25 The ndbinfo dict_obj_info Table">
       <code class="literal">
        dict_obj_info
       </code>
      </a>
     </p>
     <p>
      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 ndbinfo
      <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">
       name
      </code>
     </p>
     <p>
      The fully qualified name of the object; the same as the
      <code class="literal">
       fq_name
      </code>
      column in
      <a class="link" href="mysql-cluster-ndbinfo-dict-obj-info.html" title="25.6.17.25 The ndbinfo dict_obj_info Table">
       <code class="literal">
        dict_obj_info
       </code>
      </a>
     </p>
     <p>
      For a table, this is
      <code class="literal">
       <em class="replaceable">
        <code>
         database_name
        </code>
       </em>
       /def/
       <em class="replaceable">
        <code>
         table_name
        </code>
       </em>
      </code>
      (the same as its
      <em class="replaceable">
       <code>
        parent_name
       </code>
      </em>
      );
            for an index of any type, this takes the form
      <code class="literal">
       NDB$INDEX_
       <em class="replaceable">
        <code>
         index_id
        </code>
       </em>
       _CUSTOM
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_type
      </code>
     </p>
     <p>
      The
      <em class="replaceable">
       <code>
        DICT
       </code>
      </em>
      object type of this
            object's parent 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 of the object type
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_id
      </code>
     </p>
     <p>
      Identifier for this object's parent object; the same as
            the
      <a class="link" href="mysql-cluster-ndbinfo-dict-obj-info.html" title="25.6.17.25 The ndbinfo dict_obj_info Table">
       <code class="literal">
        dict_obj_info
       </code>
      </a>
      table's
      <code class="literal">
       id
      </code>
      column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_name
      </code>
     </p>
     <p>
      Fully qualified name of this object's parent object;
            the same as the
      <a class="link" href="mysql-cluster-ndbinfo-dict-obj-info.html" title="25.6.17.25 The ndbinfo dict_obj_info Table">
       <code class="literal">
        dict_obj_info
       </code>
      </a>
      table's
      <code class="literal">
       fq_name
      </code>
      column
     </p>
     <p>
      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 an index, the name is
      <code class="literal">
       sys/def/
       <em class="replaceable">
        <code>
         table_id
        </code>
       </em>
       /
       <em class="replaceable">
        <code>
         index_name
        </code>
       </em>
      </code>
      .
            For a primary key, it 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>
    <li class="listitem">
     <p>
      <code class="literal">
       root_type
      </code>
     </p>
     <p>
      The
      <em class="replaceable">
       <code>
        DICT
       </code>
      </em>
      object type of the root
            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 of the object type
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       root_id
      </code>
     </p>
     <p>
      Identifier for the root object; the same as the
      <a class="link" href="mysql-cluster-ndbinfo-dict-obj-info.html" title="25.6.17.25 The ndbinfo dict_obj_info Table">
       <code class="literal">
        dict_obj_info
       </code>
      </a>
      table's
      <code class="literal">
       id
      </code>
      column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       root_name
      </code>
     </p>
     <p>
      Fully qualified name of the root object; the same as the
      <a class="link" href="mysql-cluster-ndbinfo-dict-obj-info.html" title="25.6.17.25 The ndbinfo dict_obj_info Table">
       <code class="literal">
        dict_obj_info
       </code>
      </a>
      table's
      <code class="literal">
       fq_name
      </code>
      column
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       level
      </code>
     </p>
     <p>
      Level of the object in the hierarchy
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       path
      </code>
     </p>
     <p>
      Complete path to the object in the
      <em class="replaceable">
       <code>
        NDB
       </code>
      </em>
      object hierarchy; objects are
            separated by a right arrow (represented as
      <code class="literal">
       -&gt;
      </code>
      ), starting with the root object on
            the left
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       indented_name
      </code>
     </p>
     <p>
      The
      <code class="literal">
       name
      </code>
      prefixed with a right arrow
            (represented as
      <code class="literal">
       -&gt;
      </code>
      ) with a number of
            spaces preceding it that correspond to the object's
            depth in the hierarchy
     </p>
    </li>
   </ul>
  </div>
  <p>
   The
   <code class="literal">
    path
   </code>
   column is useful for obtaining a
        complete path to a given
   <code class="literal">
    NDB
   </code>
   database object
        in a single line, whereas the
   <code class="literal">
    indented_name
   </code>
   column can be used to obtain a tree-like layout of complete
        hierarchy information for a desired object.
  </p>
  <p>
   <span class="emphasis">
    <em>
     Example
    </em>
   </span>
   : Assuming the existence of a
   <code class="literal">
    test
   </code>
   database and no existing table named
   <code class="literal">
    t1
   </code>
   in this database, execute the following
        SQL statement:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa85991208"><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">CREATE</span> <span class="token keyword">TABLE</span> test<span class="token punctuation">.</span>t1 <span class="token punctuation">(</span>
    a <span class="token datatype">INT</span> <span class="token keyword">PRIMARY</span> <span class="token keyword">KEY</span><span class="token punctuation">,</span>
    b <span class="token datatype">INT</span><span class="token punctuation">,</span>
    <span class="token keyword">UNIQUE</span> <span class="token keyword">KEY</span><span class="token punctuation">(</span>b<span class="token punctuation">)</span>
<span class="token punctuation">)</span>   <span class="token keyword">ENGINE</span> <span class="token operator">=</span> <span class="token keyword">NDB</span><span class="token punctuation">;</span></code></pre>
  </div>
  <p>
   You can obtain the path to the table just created using the
        query shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa52802308"><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 prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token keyword">path</span> <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>dict_obj_tree
<span class="token prompt">    -&gt;</span> <span class="token keyword">WHERE</span> <span class="token keyword">name</span> <span class="token operator">LIKE</span> <span class="token string">'test%t1'</span><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>
<span class="token output"><span class="token punctuation">|</span> path        <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>
<span class="token output"><span class="token punctuation">|</span> test/def/t1 <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>
<span class="token output">1 row in set (0.14 sec)</span></code></pre>
  </div>
  <p>
   You can see the paths to all dependent objects of this table
        using the path to the table as the root name in a query like
        this one:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa22435575"><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 prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token keyword">path</span> <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>dict_obj_tree
<span class="token prompt">    -&gt;</span> <span class="token keyword">WHERE</span> root_name <span class="token operator">=</span> <span class="token string">'test/def/t1'</span><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 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 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> path                                                     <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 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 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> test/def/t1                                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> test/def/t1 <span class="token punctuation">-</span>&gt; sys/def/13/b                              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> test/def/t1 <span class="token punctuation">-</span>&gt; sys/def/13/b <span class="token punctuation">-</span>&gt; NDB$INDEX_15_CUSTOM       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> test/def/t1 <span class="token punctuation">-</span>&gt; sys/def/13/b$unique                       <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> test/def/t1 <span class="token punctuation">-</span>&gt; sys/def/13/b$unique <span class="token punctuation">-</span>&gt; NDB$INDEX_16_UI    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> test/def/t1 <span class="token punctuation">-</span>&gt; sys/def/13/PRIMARY                        <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span> test/def/t1 <span class="token punctuation">-</span>&gt; sys/def/13/PRIMARY <span class="token punctuation">-</span>&gt; NDB$INDEX_14_CUSTOM <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 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 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">7 rows in set (0.16 sec)</span></code></pre>
  </div>
  <p>
   To obtain a hierarchical view of the
   <code class="literal">
    t1
   </code>
   table
        with all its dependent objects, execute a query similar to this
        one which selects the indented name of each object having
   <code class="literal">
    test/def/t1
   </code>
   as the name of its root object:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa49404845"><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 prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> indented_name <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>dict_obj_tree
<span class="token prompt">    -&gt;</span> <span class="token keyword">WHERE</span> root_name <span class="token operator">=</span> <span class="token string">'test/def/t1'</span><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 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> indented_name              <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 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> test/def/t1                <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; sys/def/13/b          <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>     <span class="token punctuation">-</span>&gt; NDB$INDEX_15_CUSTOM <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; sys/def/13/b$unique   <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>     <span class="token punctuation">-</span>&gt; NDB$INDEX_16_UI     <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; sys/def/13/PRIMARY    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>     <span class="token punctuation">-</span>&gt; NDB$INDEX_14_CUSTOM <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 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">7 rows in set (0.15 sec)</span></code></pre>
  </div>
  <p>
   When working with Disk Data tables, note that, in this context,
        a tablespace or log file group is considered a root object. This
        means that you must know the name of any tablespace or log file
        group associated with a given table, or obtain this information
        from
   <a class="link" href="show-create-table.html" title="15.7.7.11 SHOW CREATE TABLE Statement">
    <code class="literal">
     SHOW CREATE TABLE
    </code>
   </a>
   and then
        querying
   <a class="link" href="information-schema-files-table.html" title="28.3.15 The INFORMATION_SCHEMA FILES Table">
    <code class="literal">
     INFORMATION_SCHEMA.FILES
    </code>
   </a>
   ,
        or similar means as shown here:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa71670592"><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 prompt">mysql&gt;</span> <span class="token keyword">SHOW</span> <span class="token keyword">CREATE</span> <span class="token keyword">TABLE</span> test<span class="token punctuation">.</span>dt_1\G
<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 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> 1. row <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 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>
       Table<span class="token punctuation">:</span> dt_1
Create Table<span class="token punctuation">:</span> CREATE TABLE `dt_1` (
  `member_id` int unsigned NOT NULL AUTO_INCREMENT,
  `last_name` varchar(50) NOT NULL,
  `first_name` varchar(50) NOT NULL,
  `dob` date NOT NULL,
  `joined` date NOT NULL,
  PRIMARY KEY (`member_id`),
  KEY `last_name` (`last_name`,`first_name`)
) /<span class="token punctuation">*</span>!50100 TABLESPACE `ts_1` STORAGE DISK <span class="token punctuation">*</span>/ ENGINE=ndbcluster DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
</span><span class="token output">1 row in set (0.00 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> <span class="token keyword">DISTINCT</span> TABLESPACE_NAME<span class="token punctuation">,</span> LOGFILE_GROUP_NAME
<span class="token prompt">    -&gt;</span> <span class="token keyword">FROM</span> INFORMATION_SCHEMA<span class="token punctuation">.</span>FILES <span class="token keyword">WHERE</span> TABLESPACE_NAME<span class="token operator">=</span><span class="token string">'ts_1'</span><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 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> TABLESPACE_NAME <span class="token punctuation">|</span> LOGFILE_GROUP_NAME <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 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> ts_1            <span class="token punctuation">|</span> lg_1               <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 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">1 row in set (0.00 sec)</span></code></pre>
  </div>
  <p>
   Now you can obtain hierarchical information for the table,
        tablespace, and log file group like this:
  </p>
  <div class="copytoclipboard-wrapper">
   <pre class="programlisting language-sql"><div class="docs-select-all right" id="sa60782020"><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 prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> indented_name <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>dict_obj_tree
<span class="token prompt">    -&gt;</span> <span class="token keyword">WHERE</span> root_name <span class="token operator">=</span> <span class="token string">'test/def/dt_1'</span><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 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> indented_name              <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 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> test/def/dt_1              <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; sys/def/23/last_name  <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>     <span class="token punctuation">-</span>&gt; NDB$INDEX_25_CUSTOM <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; sys/def/23/PRIMARY    <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>     <span class="token punctuation">-</span>&gt; NDB$INDEX_24_CUSTOM <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 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">5 rows in set (0.15 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> indented_name <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>dict_obj_tree
<span class="token prompt">    -&gt;</span> <span class="token keyword">WHERE</span> root_name <span class="token operator">=</span> <span class="token string">'ts_1'</span><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>
<span class="token output"><span class="token punctuation">|</span> indented_name   <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>
<span class="token output"><span class="token punctuation">|</span> ts_1            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; data_1.dat <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; data_2.dat <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>
<span class="token output">3 rows in set (0.17 sec)</span>

<span class="token prompt">mysql&gt;</span> <span class="token keyword">SELECT</span> indented_name <span class="token keyword">FROM</span> ndbinfo<span class="token punctuation">.</span>dict_obj_tree
<span class="token prompt">    -&gt;</span> <span class="token keyword">WHERE</span> root_name <span class="token operator">LIKE</span> <span class="token string">'lg_1'</span><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>
<span class="token output"><span class="token punctuation">|</span> indented_name   <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>
<span class="token output"><span class="token punctuation">|</span> lg_1            <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; undo_1.log <span class="token punctuation">|</span></span>
<span class="token output"><span class="token punctuation">|</span>   <span class="token punctuation">-</span>&gt; undo_2.log <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>
<span class="token output">3 rows in set (0.16 sec)</span></code></pre>
  </div>
 </div>
 <br/>
</div>
