> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# showTable

<div className="kinetica-javadoc">
  <ul className="member-list">
    <li>
      <div className="section detail" id="showTable(com.gpudb.protocol.ShowTableRequest)">
        <h3>showTable</h3>
        <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ShowTableResponse" title="class in com.gpudb.protocol">ShowTableResponse</a></span> <span className="element-name">showTable</span><wbr /><span className="parameters">(<a href="/content/api/java/com/gpudb/protocol/ShowTableRequest" title="class in com.gpudb.protocol">ShowTableRequest</a> request)</span> throws <span className="exceptions"><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></span></div>

        <div className="block">
          Retrieves detailed information about a table, view, or schema, specified in <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest#getTableName()"><code>tableName</code></a>. If the supplied <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest#getTableName()"><code>tableName</code></a> is a schema the call can return information about either the schema itself or the tables and views it contains. If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest#getTableName()"><code>tableName</code></a> is empty, information about all schemas will be returned.
          <p> If the option <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#GET_SIZES"><code>GET\_SIZES</code></a> is set to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a>, then the number of records in each table is returned (in <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getSizes()"><code>sizes</code></a> and <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getFullSizes()"><code>fullSizes</code></a>), along with the total number of objects across all requested tables (in <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalSize()"><code>totalSize</code></a> and <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalFullSize()"><code>totalFullSize</code></a>). </p>
          <p> For a schema, setting the <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> option to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> returns only information about the schema itself; setting <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> returns a list of tables and views contained in the schema, along with their corresponding detail. </p>
          <p> To retrieve a list of every table, view, and schema in the database, set <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest#getTableName()"><code>tableName</code></a> to '\*' and <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a>. When doing this, the returned <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalSize()"><code>totalSize</code></a> and <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalFullSize()"><code>totalFullSize</code></a> will not include the sizes of non-base tables (e.g., filters, views, joins, etc.).</p>
        </div>

        <div className="dl notes">
          <div className="dt">Parameters:</div>
          <div className="dd"><code>request</code> - <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest" title="class in com.gpudb.protocol"><code>Request</code></a> object containing the parameters for the operation.</div>
          <div className="dt">Returns:</div>
          <div className="dd"><a href="/content/api/java/com/gpudb/protocol/ShowTableResponse" title="class in com.gpudb.protocol"><code>Response</code></a> object containing the results of the operation.</div>
          <div className="dt">Throws:</div>
          <div className="dd"><code><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></code> - if an error occurs during the operation.</div>
        </div>
      </div>
    </li>

    <li>
      <div className="section detail" id="showTable(java.lang.String,java.util.Map)">
        <h3>showTable</h3>
        <div className="member-signature"><span className="modifiers">public</span> <span className="return-type"><a href="/content/api/java/com/gpudb/protocol/ShowTableResponse" title="class in com.gpudb.protocol">ShowTableResponse</a></span> <span className="element-name">showTable</span><wbr /><span className="parameters">(<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a> tableName, <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link">Map</a>\<<a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a>,<wbr /><a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" className="external-link">String</a>> options)</span> throws <span className="exceptions"><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></span></div>

        <div className="block">
          Retrieves detailed information about a table, view, or schema, specified in <code>tableName</code>. If the supplied <code>tableName</code> is a schema the call can return information about either the schema itself or the tables and views it contains. If <code>tableName</code> is empty, information about all schemas will be returned.
          <p> If the option <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#GET_SIZES"><code>GET\_SIZES</code></a> is set to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a>, then the number of records in each table is returned (in <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getSizes()"><code>sizes</code></a> and <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getFullSizes()"><code>fullSizes</code></a>), along with the total number of objects across all requested tables (in <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalSize()"><code>totalSize</code></a> and <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalFullSize()"><code>totalFullSize</code></a>). </p>
          <p> For a schema, setting the <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> option to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> returns only information about the schema itself; setting <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> returns a list of tables and views contained in the schema, along with their corresponding detail. </p>
          <p> To retrieve a list of every table, view, and schema in the database, set <code>tableName</code> to '\*' and <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> to <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a>. When doing this, the returned <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalSize()"><code>totalSize</code></a> and <a href="/content/api/java/com/gpudb/protocol/ShowTableResponse#getTotalFullSize()"><code>totalFullSize</code></a> will not include the sizes of non-base tables (e.g., filters, views, joins, etc.).</p>
        </div>

        <div className="dl notes">
          <div className="dt">Parameters:</div>
          <div className="dd"><code>tableName</code> - Name of the table for which to retrieve the information, in \[schema\_name.]table\_name format, using standard <a href="/content/concepts/tables/#table-name-resolution" target="_top">name resolution rules</a>. If blank, then returns information about all tables and views.</div>

          <div className="dd">
            <code>options</code> - Optional parameters.

            <ul>
              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#DEPENDENCIES"><code>DEPENDENCIES</code></a>: Include view dependencies in the output. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FORCE_SYNCHRONOUS"><code>FORCE\_SYNCHRONOUS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then the table sizes will wait for read lock before returning. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#GET_ACCESS_DATA"><code>GET\_ACCESS\_DATA</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then data about the last read, write, alter and create will be returned. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#GET_CACHED_SIZES"><code>GET\_CACHED\_SIZES</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. This version will return the sizes cached at rank 0, which may be stale if there is a multihead insert occurring. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#GET_SIZES"><code>GET\_SIZES</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#REFERENCING_MATERIALIZED_VIEWS"><code>REFERENCING\_MATERIALIZED\_VIEWS</code></a>: Include materialized views using this table as a source in the output. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SKIP_ADDITIONAL_INFO"><code>SKIP\_ADDITIONAL\_INFO</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then the response will not populate the additional\_info field. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#NO_ERROR_IF_NOT_EXISTS"><code>NO\_ERROR\_IF\_NOT\_EXISTS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> will return an error if the provided <code>tableName</code> does not exist. If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then it will return an empty result. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SKIP_TEMP_SCHEMAS"><code>SKIP\_TEMP\_SCHEMAS</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then the table list will not include tables from SYS\_TEMP and other system temporary schemas. This is the default behavior for non-admin users. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a>: If <code>tableName</code> is a schema, then <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> will return information about the tables and views in the schema, and <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> will return information about the schema itself. If <code>tableName</code> is a table or view, <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> must be <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>. If <code>tableName</code> is empty, then <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#SHOW_CHILDREN"><code>SHOW\_CHILDREN</code></a> must be <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a>. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a>.
              </li>

              <li>
                <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#GET_COLUMN_INFO"><code>GET\_COLUMN\_INFO</code></a>: If <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> then column info (memory usage, etc) will be returned. Supported values:

                <ul>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#TRUE"><code>TRUE</code></a> </li>
                  <li><a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a> </li>
                </ul>

                The default value is <a href="/content/api/java/com/gpudb/protocol/ShowTableRequest.Options#FALSE"><code>FALSE</code></a>.
              </li>
            </ul>

            The default value is an empty <a href="https://docs.oracle.com/en/java/javase/11/docs/api/java.base/java/util/Map.html" title="class or interface in java.util" className="external-link"><code>Map</code></a>.
          </div>

          <div className="dt">Returns:</div>
          <div className="dd"><a href="/content/api/java/com/gpudb/protocol/ShowTableResponse" title="class in com.gpudb.protocol"><code>Response</code></a> object containing the results of the operation.</div>
          <div className="dt">Throws:</div>
          <div className="dd"><code><a href="/content/api/java/com/gpudb/GPUdbException" title="class in com.gpudb">GPUdbException</a></code> - if an error occurs during the operation.</div>
        </div>
      </div>
    </li>
  </ul>
</div>