<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="mysql-cluster-ndbinfo-foreign-keys">
      </a>
      25.6.17.37 The ndbinfo foreign_keys Table
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045089201216">
  </a>
  <p>
   The
   <code class="literal">
    foreign_keys
   </code>
   table provides information
        about foreign keys on
   <code class="literal">
    NDB
   </code>
   tables. This table
        has the following columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       object_id
      </code>
     </p>
     <p>
      The foreign key's object ID
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       name
      </code>
     </p>
     <p>
      Name of the foreign key
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_table
      </code>
     </p>
     <p>
      The name of the foreign key's parent table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_columns
      </code>
     </p>
     <p>
      A comma-delimited list of parent columns
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       child_table
      </code>
     </p>
     <p>
      The name of the child table
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       child_columns
      </code>
     </p>
     <p>
      A comma-separated list of child columns
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       parent_index
      </code>
     </p>
     <p>
      Name of the parent index
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       child_index
      </code>
     </p>
     <p>
      Name of the child index
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       on_update_action
      </code>
     </p>
     <p>
      The
      <code class="literal">
       ON UPDATE
      </code>
      action specified for the
            foreign key; one of
      <code class="literal">
       No Action
      </code>
      ,
      <code class="literal">
       Restrict
      </code>
      ,
      <code class="literal">
       Cascade
      </code>
      ,
      <code class="literal">
       Set Null
      </code>
      , or
      <code class="literal">
       Set
            Default
      </code>
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       on_delete_action
      </code>
     </p>
     <p>
      The
      <code class="literal">
       ON DELETE
      </code>
      action specified for the
            foreign key; one of
      <code class="literal">
       No Action
      </code>
      ,
      <code class="literal">
       Restrict
      </code>
      ,
      <code class="literal">
       Cascade
      </code>
      ,
      <code class="literal">
       Set Null
      </code>
      , or
      <code class="literal">
       Set
            Default
      </code>
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
