<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-schema-auto-increment-columns">
      </a>
      30.4.3.24 The schema_auto_increment_columns View
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045062588640">
  </a>
  <a class="indexterm" name="idm46045062587136">
  </a>
  <p>
   This view indicates which tables have
   <code class="literal">
    AUTO_INCREMENT
   </code>
   columns and provides
          information about those columns, such as the current and
          maximum column values and the usage ratio (ratio of used to
          possible values). By default, rows are sorted by descending
          usage ratio and maximum column value.
  </p>
  <p>
   Tables in these schemas are excluded from view output:
   <code class="literal">
    mysql
   </code>
   ,
   <code class="literal">
    sys
   </code>
   ,
   <code class="literal">
    INFORMATION_SCHEMA
   </code>
   ,
   <code class="literal">
    performance_schema
   </code>
   .
  </p>
  <p>
   The
   <a class="link" href="sys-schema-auto-increment-columns.html" title="30.4.3.24 The schema_auto_increment_columns View">
    <code class="literal">
     schema_auto_increment_columns
    </code>
   </a>
   view has these columns:
  </p>
  <div class="itemizedlist">
   <ul class="itemizedlist" style="list-style-type: disc; ">
    <li class="listitem">
     <p>
      <code class="literal">
       table_schema
      </code>
     </p>
     <p>
      The schema that contains the table.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       table_name
      </code>
     </p>
     <p>
      The table that contains the
      <code class="literal">
       AUTO_INCREMENT
      </code>
      column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       column_name
      </code>
     </p>
     <p>
      The name of the
      <code class="literal">
       AUTO_INCREMENT
      </code>
      column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       data_type
      </code>
     </p>
     <p>
      The data type of the column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       column_type
      </code>
     </p>
     <p>
      The column type of the column, which is the data type plus
              possibly other information. For example, for a column with
              a
      <code class="literal">
       bigint(20) unsigned
      </code>
      column type, the
              data type is just
      <code class="literal">
       bigint
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       is_signed
      </code>
     </p>
     <p>
      Whether the column type is signed.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       is_unsigned
      </code>
     </p>
     <p>
      Whether the column type is unsigned.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       max_value
      </code>
     </p>
     <p>
      The maximum permitted value for the column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       auto_increment
      </code>
     </p>
     <p>
      The current
      <code class="literal">
       AUTO_INCREMENT
      </code>
      value for
              the column.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       auto_increment_ratio
      </code>
     </p>
     <p>
      The ratio of used to permitted values for the column. This
              indicates how much of the sequence of values is
      <span class="quote">
       “
       <span class="quote">
        used up.
       </span>
       ”
      </span>
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
