<div id="docs-body">
 <div class="section">
  <div class="titlepage">
   <div>
    <div>
     <h3 class="title">
      <a name="information-schema-view-table-usage-table">
      </a>
      28.3.49 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table
     </h3>
    </div>
   </div>
  </div>
  <a class="indexterm" name="idm46045077931056">
  </a>
  <p>
   The
   <a class="link" href="information-schema-view-table-usage-table.html" title="28.3.49 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table">
    <code class="literal">
     VIEW_TABLE_USAGE
    </code>
   </a>
   table provides
      access to information about tables and views used in view
      definitions.
  </p>
  <p>
   You can see information only for views for which you have some
      privilege, and only for tables for which you have some privilege.
  </p>
  <p>
   The
   <a class="link" href="information-schema-view-table-usage-table.html" title="28.3.49 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table">
    <code class="literal">
     VIEW_TABLE_USAGE
    </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">
       VIEW_CATALOG
      </code>
     </p>
     <p>
      The name of the catalog to which the view belongs. This value
          is always
      <code class="literal">
       def
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       VIEW_SCHEMA
      </code>
     </p>
     <p>
      The name of the schema (database) to which the view belongs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       VIEW_NAME
      </code>
     </p>
     <p>
      The name of the view.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_CATALOG
      </code>
     </p>
     <p>
      The name of the catalog to which the table or view used in the
          view definition belongs. This value is always
      <code class="literal">
       def
      </code>
      .
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_SCHEMA
      </code>
     </p>
     <p>
      The name of the schema (database) to which the table or view
          used in the view definition belongs.
     </p>
    </li>
    <li class="listitem">
     <p>
      <code class="literal">
       TABLE_NAME
      </code>
     </p>
     <p>
      The name of the table or view used in the view definition.
     </p>
    </li>
   </ul>
  </div>
 </div>
 <br/>
</div>
