<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-check-constraints-table">
      </a>
      28.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045080314496">
  </a>
  <p>
   <a class="link" href="create-table.html" title="15.1.20 CREATE TABLE Statement">
    <code class="literal">
     CREATE TABLE
    </code>
   </a>
   supports the core
      features of table and column
   <code class="literal">
    CHECK
   </code>
   constraints;
      the
   <a class="link" href="information-schema-check-constraints-table.html" title="28.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table">
    <code class="literal">
     CHECK_CONSTRAINTS
    </code>
   </a>
   table provides
      information about these constraints.
  </p>
  <p>
   The
   <a class="link" href="information-schema-check-constraints-table.html" title="28.3.5 The INFORMATION_SCHEMA CHECK_CONSTRAINTS Table">
    <code class="literal">
     CHECK_CONSTRAINTS
    </code>
   </a>
   table has these
      columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       CONSTRAINT_CATALOG
      </code>
     </p>
     <p>
      The name of the catalog to which the constraint belongs. This
          value is always
      <code class="literal">
       def
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CONSTRAINT_SCHEMA
      </code>
     </p>
     <p>
      The name of the schema (database) to which the constraint
          belongs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CONSTRAINT_NAME
      </code>
     </p>
     <p>
      The name of the constraint.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       CHECK_CLAUSE
      </code>
     </p>
     <p>
      The expression that specifies the constraint condition.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
