<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h4 class="title">
      <a name="sys-schema-object-overview">
      </a>
      30.4.3.26 The schema_object_overview View
     </h4>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045062521680">
  </a>
  <a class="indexterm" name="idm46045062520176">
  </a>
  <p>
   This view summarizes the types of objects within each schema.
          By default, rows are sorted by schema and object type.
  </p>
  <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;">
   <div class="admon-title">
    Note
   </div>
   <p>
    For MySQL instances with a large number of objects, this
            view might take a long time to execute.
   </p>
  </div>
  <p>
   The
   <a class="link" href="sys-schema-object-overview.html" title="30.4.3.26 The schema_object_overview View">
    <code class="literal">
     schema_object_overview
    </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">
       db
      </code>
     </p>
     <p>
      The schema name.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       object_type
      </code>
     </p>
     <p>
      The object type:
      <code class="literal">
       BASE TABLE
      </code>
      ,
      <code class="literal">
       INDEX
              (
       <em class="replaceable">
        <code>
         index_type
        </code>
       </em>
       )
      </code>
      ,
      <code class="literal">
       EVENT
      </code>
      ,
      <code class="literal">
       FUNCTION
      </code>
      ,
      <code class="literal">
       PROCEDURE
      </code>
      ,
      <code class="literal">
       TRIGGER
      </code>
      ,
      <code class="literal">
       VIEW
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       count
      </code>
     </p>
     <p>
      The number of objects in the schema of the given type.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
