<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-dictionary-tables">
      </a>
      25.6.17.24 The ndbinfo dictionary_tables Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089773792">
  </a>
  <p>
   This table provides
   <code class="literal">
    NDB
   </code>
   dictionary
        information for
   <code class="literal">
    NDB
   </code>
   tables.
   <code class="literal">
    dictionary_tables
   </code>
   contains the columns listed
        here:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       table_id
      </code>
     </p>
     <p>
      The table' unique ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       database_name
      </code>
     </p>
     <p>
      Name of the database containing the table
     </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">
       status
      </code>
     </p>
     <p>
      The table status; 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>
      .
            (See
      <a class="ulink" href="/doc/ndbapi/en/ndb-object.html#ndb-object-status" target="_top">
       Object::Status
      </a>
      , for more
            information about object status values.)
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       attributes
      </code>
     </p>
     <p>
      Number of table attributes
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       primary_key_cols
      </code>
     </p>
     <p>
      Number of columns in the table's primary key
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       primary_key
      </code>
     </p>
     <p>
      A comma-separated list of the columns in the table's
            primary key
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       storage
      </code>
     </p>
     <p>
      Type of storage used by the table; one of
      <code class="literal">
       memory
      </code>
      ,
      <code class="literal">
       disk
      </code>
      , or
      <code class="literal">
       default
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       logging
      </code>
     </p>
     <p>
      Whether logging is enabled for this table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       dynamic
      </code>
     </p>
     <p>
      <code class="literal">
       1
      </code>
      if the table is dynamic, otherwise
      <code class="literal">
       0
      </code>
      ; the table is considered dynamic if
      <code class="literal">
       <em class="replaceable">
        <code>
         table
        </code>
       </em>
       -&gt;
      </code>
      <a class="ulink" href="/doc/ndbapi/en/ndb-table.html#ndb-table-getforcevarpart" target="_top">
       <code class="literal">
        getForceVarPart()
       </code>
      </a>
      is true, or if at least one table column is dynamic
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       read_backup
      </code>
     </p>
     <p>
      <code class="literal">
       1
      </code>
      if read from any replica
            (
      <code class="literal">
       READ_BACKUP
      </code>
      option is enabled for this
            table, otherwise
      <code class="literal">
       0
      </code>
      ; see
      <a class="xref" href="create-table-ndb-comment-options.html" title="15.1.20.12 Setting NDB Comment Options">
       Section 15.1.20.12, “Setting NDB Comment Options”
      </a>
      )
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       fully_replicated
      </code>
     </p>
     <p>
      <code class="literal">
       1
      </code>
      if
      <code class="literal">
       FULLY_REPLICATED
      </code>
      is enabled for this table (each data node in the cluster has
            a complete copy of the table),
      <code class="literal">
       0
      </code>
      if not;
            see
      <a class="xref" href="create-table-ndb-comment-options.html" title="15.1.20.12 Setting NDB Comment Options">
       Section 15.1.20.12, “Setting NDB Comment Options”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       checksum
      </code>
     </p>
     <p>
      If this table uses a checksum, the value in this column is
      <code class="literal">
       1
      </code>
      ; if not, it is
      <code class="literal">
       0
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       row_size
      </code>
     </p>
     <p>
      The amount of data, in bytes that can be stored in one row,
            not including any blob data stored separately in blob
            tables; see
      <a class="ulink" href="/doc/ndbapi/en/ndb-table.html#ndb-table-getrowsizeinbytes" target="_top">
       Table::getRowSizeInBytes()
      </a>
      ,
            in the API documentation, for more information
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       min_rows
      </code>
     </p>
     <p>
      Minimum number of rows, as used for calculating partitions;
            see
      <a class="ulink" href="/doc/ndbapi/en/ndb-table.html#ndb-table-getminrows" target="_top">
       Table::getMinRows()
      </a>
      , in the API
            documentation, for more information
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       max_rows
      </code>
     </p>
     <p>
      Maximum number of rows, as used for calculating partitions;
            see
      <a class="ulink" href="/doc/ndbapi/en/ndb-table.html#ndb-table-getmaxrows" target="_top">
       Table::getMaxRows()
      </a>
      , in the API
            documentation, for more information
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       tablespace
      </code>
     </p>
     <p>
      ID of the tablespace to which the table belongs, if any;
            this is
      <code class="literal">
       0
      </code>
      , if the table does not use data
            on disk
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       fragment_type
      </code>
     </p>
     <p>
      The table's fragment type; one of
      <code class="literal">
       Single
      </code>
      ,
      <code class="literal">
       AllSmall
      </code>
      ,
      <code class="literal">
       AllMedium
      </code>
      ,
      <code class="literal">
       AllLarge
      </code>
      ,
      <code class="literal">
       DistrKeyHash
      </code>
      ,
      <code class="literal">
       DistrKeyLin
      </code>
      ,
      <code class="literal">
       UserDefined
      </code>
      ,
      <code class="literal">
       unused
      </code>
      ,
            or
      <code class="literal">
       HashMapPartition
      </code>
      ; for more
            information, see
      <a class="ulink" href="/doc/ndbapi/en/ndb-object.html#ndb-object-fragmenttype" target="_top">
       Object::FragmentType
      </a>
      ,
            in the NDB API documentation
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       hash_map
      </code>
     </p>
     <p>
      The hash map used by the table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       fragments
      </code>
     </p>
     <p>
      Number of table fragments
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       partitions
      </code>
     </p>
     <p>
      Number of partitions used by the table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       partition_balance
      </code>
     </p>
     <p>
      Type of partition balance used, if any; one of
      <code class="literal">
       FOR_RP_BY_NODE
      </code>
      ,
      <code class="literal">
       FOR_RA_BY_NODE
      </code>
      ,
      <code class="literal">
       FOR_RP_BY_LDM
      </code>
      ,
      <code class="literal">
       FOR_RA_BY_LDM
      </code>
      ,
      <code class="literal">
       FOR_RA_BY_LDM_X_2
      </code>
      ,
      <code class="literal">
       FOR_RA_BY_LDM_X_3
      </code>
      , or
      <code class="literal">
       FOR_RA_BY_LDM_X_4
      </code>
      ; see
      <a class="xref" href="create-table-ndb-comment-options.html" title="15.1.20.12 Setting NDB Comment Options">
       Section 15.1.20.12, “Setting NDB Comment Options”
      </a>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       contains_GCI
      </code>
     </p>
     <p>
      <code class="literal">
       1
      </code>
      if the table includes a global
            checkpoint index, otherwise
      <code class="literal">
       0
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       single_user_mode
      </code>
     </p>
     <p>
      Type of access allowed to the table when single user mode is
            in effect; one of
      <code class="literal">
       locked
      </code>
      ,
      <code class="literal">
       read_only
      </code>
      , or
      <code class="literal">
       read_write
      </code>
      ; these are equivalent to the
            values
      <code class="literal">
       SingleUserModeLocked
      </code>
      ,
      <code class="literal">
       SingleUserModeReadOnly
      </code>
      , and
      <code class="literal">
       SingleUserModeReadWrite
      </code>
      , respectively, of
            the
      <a class="ulink" href="/doc/ndbapi/en/ndb-table.html#ndb-table-singleusermode" target="_top">
       <code class="literal">
        Table::SingleUserMode
       </code>
      </a>
      type in the NDB API
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       force_var_part
      </code>
     </p>
     <p>
      This is
      <code class="literal">
       1
      </code>
      if
      <code class="literal">
       <em class="replaceable">
        <code>
         table
        </code>
       </em>
       -&gt;
      </code>
      <a class="ulink" href="/doc/ndbapi/en/ndb-table.html#ndb-table-getforcevarpart" target="_top">
       <code class="literal">
        getForceVarPart()
       </code>
      </a>
      is true for this table, and
      <code class="literal">
       0
      </code>
      if it is
            not
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       GCI_bits
      </code>
     </p>
     <p>
      Used in testing
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       author_bits
      </code>
     </p>
     <p>
      Used in testing
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
