> ## 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.

# gpudb::ShowTableRequest

> gpudb::ShowTableRequest — Kinetica C++ API

<div className="kinetica-doxygen">
  <div className="contents">
    <p>A set of parameters for <a className="el" href="/content/api/cpp/classgpudb_1_1GPUdb#ae446b45c99e9b4afa26726bce8ad23cc">GPUdb::showTable</a>. <a href="#details">More...</a></p>
    <p><code>#include \<<a className="el" href="/content/api/cpp/show__table_8h_source">gpudb/protocol/show\_table.h</a>></code></p>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Public Member Functions</h2>
        </td>
      </tr>

      <tr className="memitem:acb588fa424afe865d67d8184b9da9ddc" id="r_acb588fa424afe865d67d8184b9da9ddc">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#acb588fa424afe865d67d8184b9da9ddc">ShowTableRequest</a> ()</td>
      </tr>

      <tr className="memdesc:acb588fa424afe865d67d8184b9da9ddc">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs a <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest" title="A set of parameters for GPUdb::showTable.">ShowTableRequest</a> object with default parameters. <br /></td>
      </tr>

      <tr className="separator:acb588fa424afe865d67d8184b9da9ddc">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:a3da97438eff28a4f02469eb5fabd0d23" id="r_a3da97438eff28a4f02469eb5fabd0d23">
        <td className="memItemLeft" align="right" valign="top"> </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a3da97438eff28a4f02469eb5fabd0d23">ShowTableRequest</a> (const std::string \&tableName\_, const std::map\< std::string, std::string > \&options\_)</td>
      </tr>

      <tr className="memdesc:a3da97438eff28a4f02469eb5fabd0d23">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Constructs a <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest" title="A set of parameters for GPUdb::showTable.">ShowTableRequest</a> object with the specified parameters. <br /></td>
      </tr>

      <tr className="separator:a3da97438eff28a4f02469eb5fabd0d23">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <table className="memberdecls">
      <tr className="heading">
        <td colSpan="2">
          <h2 className="groupheader"> Public Attributes</h2>
        </td>
      </tr>

      <tr className="memitem:a4b7e6b1e0720e0453914de2e455d9b8e" id="r_a4b7e6b1e0720e0453914de2e455d9b8e">
        <td className="memItemLeft" align="right" valign="top">std::string </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a></td>
      </tr>

      <tr className="memdesc:a4b7e6b1e0720e0453914de2e455d9b8e">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">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>. <br /></td>
      </tr>

      <tr className="separator:a4b7e6b1e0720e0453914de2e455d9b8e">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>

      <tr className="memitem:ab65017c91a0dd2b5ecbf5c37b2b27930" id="r_ab65017c91a0dd2b5ecbf5c37b2b27930">
        <td className="memItemLeft" align="right" valign="top">std::map\< std::string, std::string > </td>
        <td className="memItemRight" valign="bottom"><a className="el" href="#ab65017c91a0dd2b5ecbf5c37b2b27930">options</a></td>
      </tr>

      <tr className="memdesc:ab65017c91a0dd2b5ecbf5c37b2b27930">
        <td className="mdescLeft"> </td>
        <td className="mdescRight">Optional parameters. <br /></td>
      </tr>

      <tr className="separator:ab65017c91a0dd2b5ecbf5c37b2b27930">
        <td className="memSeparator" colSpan="2"> </td>
      </tr>
    </table>

    <h2 className="groupheader">Detailed Description</h2>

    <div className="textblock">
      <p>A set of parameters for <a className="el" href="/content/api/cpp/classgpudb_1_1GPUdb#ae446b45c99e9b4afa26726bce8ad23cc">GPUdb::showTable</a>. </p>
      <p>Retrieves detailed information about a table, view, or schema, specified in <a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a>. If the supplied <a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a> is a schema the call can return information about either the schema itself or the tables and views it contains. If <a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a> is empty, information about all schemas will be returned.</p>
      <p>If the option <a className="el" href="/content/api/cpp/namespacegpudb#a08e495592c514c3cb43220410cb8e8f1">get\_sizes</a> is set to <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a>, then the number of records in each table is returned (in <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse#ac974c9256b30169d9ec3ec62eeb3c36a">sizes</a> and <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse#afd86694abebad6e0da3659d7a80193f6">fullSizes</a>), along with the total number of objects across all requested tables (in <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse#a8807aae341abb63dc99cc034324e29e8">totalSize</a> and <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse#a018a4b950c65fe2365d8267b29d87694">totalFullSize</a>).</p>
      <p>For a schema, setting the <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_children</a> option to <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">false</a> returns only information about the schema itself; setting <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_children</a> to <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</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 className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a> to '\*' and <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_children</a> to <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a>. When doing this, the returned <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse#a8807aae341abb63dc99cc034324e29e8">totalSize</a> and <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse#a018a4b950c65fe2365d8267b29d87694">totalFullSize</a> will not include the sizes of non-base tables (e.g., filters, views, joins, etc.). </p>
      <p className="definition">Definition at line <a className="el" href="/content/api/cpp/show__table_8h_source#l00044">44</a> of file <a className="el" href="/content/api/cpp/show__table_8h_source">show\_table.h</a>.</p>
    </div>

    <h2 className="groupheader">Constructor & Destructor Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#acb588fa424afe865d67d8184b9da9ddc">◆ </a></span>ShowTableRequest() <span className="overload">\[1/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">gpudb::ShowTableRequest::ShowTableRequest </td>
                  <td>(</td>

                  <td className="paramname">
                    <span className="paramname">
                      <span className="em" />
                    </span>
                  </td>

                  <td>)</td>

                  <td />
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Constructs a <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest" title="A set of parameters for GPUdb::showTable.">ShowTableRequest</a> object with default parameters. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/show__table_8h_source#l00049">49</a> of file <a className="el" href="/content/api/cpp/show__table_8h_source">show\_table.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a3da97438eff28a4f02469eb5fabd0d23">◆ </a></span>ShowTableRequest() <span className="overload">\[2/2]</span></h2>

    <div className="memitem">
      <div className="memproto">
        <table className="mlabels">
          <tr>
            <td className="mlabels-left">
              <table className="memname">
                <tr>
                  <td className="memname">gpudb::ShowTableRequest::ShowTableRequest </td>
                  <td>(</td>
                  <td className="paramtype">const std::string &</td>
                  <td className="paramname"><span className="paramname"><span className="em">tableName\_</span></span>, </td>
                </tr>

                <tr>
                  <td className="paramkey" />

                  <td />

                  <td className="paramtype">const std::map\< std::string, std::string > &</td>
                  <td className="paramname"><span className="paramname"><span className="em">options\_</span></span> )</td>
                </tr>
              </table>
            </td>

            <td className="mlabels-right"> <span className="mlabels"><span className="mlabel inline">inline</span></span> </td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Constructs a <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest" title="A set of parameters for GPUdb::showTable.">ShowTableRequest</a> object with the specified parameters. </p>

        <div className="dl params">
          <div className="dt">Parameters</div>

          <div className="dd">
            <table className="params">
              <tr>
                <td className="paramdir">\[in]</td>
                <td className="paramname">tableName\_</td>
                <td>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. </td>
              </tr>

              <tr>
                <td className="paramdir">\[in]</td>
                <td className="paramname">options\_</td>

                <td>
                  Optional parameters.

                  <ul>
                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a735630dad9efd53c31b0b0fa52ae1ad1">show\_table\_dependencies</a>: Include view dependencies in the output. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#abd45e351002cdc18070124420e622613">show\_table\_force\_synchronous</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then the table sizes will wait for read lock before returning. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a4887573e85d4f28b7cc65d6b749ca916">show\_table\_get\_access\_data</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then data about the last read, write, alter and create will be returned. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#af46b7d7cfe0ac4e0c7684c38a05ca8bb">show\_table\_get\_cached\_sizes</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</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 className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a08e495592c514c3cb43220410cb8e8f1">show\_table\_get\_sizes</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a20222de151678b742be3a6813ae4391b">show\_table\_referencing\_materialized\_views</a>: Include materialized views using this table as a source in the output. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a9687184475da56c512706aa32bded1e4">show\_table\_skip\_additional\_info</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then the response will not populate the additional\_info field. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#adfe860ba6674377154ea7638965ab8ff">show\_table\_no\_error\_if\_not\_exists</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">false</a> will return an error if the provided <span className="em arg">tableName\_</span> does not exist. If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then it will return an empty result. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#acd4480b6f7845086f4ebd787cc2f3038">show\_table\_skip\_temp\_schemas</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</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 className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_table\_show\_children</a>: If <span className="em arg">tableName\_</span> is a schema, then <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> will return information about the tables and views in the schema, and <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">false</a> will return information about the schema itself. If <span className="em arg">tableName\_</span> is a table or view, <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_children</a> must be <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">false</a>. If <span className="em arg">tableName\_</span> is empty, then <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_children</a> must be <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a>. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a>.
                    </li>

                    <li>
                      <a className="el" href="/content/api/cpp/namespacegpudb#a16da9c4b995d47af198c8ad820432a6c">show\_table\_get\_column\_info</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then column info (memory usage, etc) will be returned. Supported values:

                      <ul>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
                        <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
                      </ul>

                      The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
                    </li>
                  </ul>

                  The default value is an empty map.
                </td>
              </tr>
            </table>
          </div>
        </div>

        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/show__table_8h_source#l00258">258</a> of file <a className="el" href="/content/api/cpp/show__table_8h_source">show\_table.h</a>.</p>
      </div>
    </div>

    <h2 className="groupheader">Member Data Documentation</h2>
    <h2 className="memtitle"><span className="permalink"><a href="#ab65017c91a0dd2b5ecbf5c37b2b27930">◆ </a></span>options</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">std::map\<std::string, std::string> gpudb::ShowTableRequest::options</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>Optional parameters. </p>

        <ul>
          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a735630dad9efd53c31b0b0fa52ae1ad1">show\_table\_dependencies</a>: Include view dependencies in the output. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#abd45e351002cdc18070124420e622613">show\_table\_force\_synchronous</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then the table sizes will wait for read lock before returning. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a4887573e85d4f28b7cc65d6b749ca916">show\_table\_get\_access\_data</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then data about the last read, write, alter and create will be returned. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#af46b7d7cfe0ac4e0c7684c38a05ca8bb">show\_table\_get\_cached\_sizes</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</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 className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a08e495592c514c3cb43220410cb8e8f1">show\_table\_get\_sizes</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a20222de151678b742be3a6813ae4391b">show\_table\_referencing\_materialized\_views</a>: Include materialized views using this table as a source in the output. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a9687184475da56c512706aa32bded1e4">show\_table\_skip\_additional\_info</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then the response will not populate the additional\_info field. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#adfe860ba6674377154ea7638965ab8ff">show\_table\_no\_error\_if\_not\_exists</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">false</a> will return an error if the provided <a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a> does not exist. If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then it will return an empty result. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#acd4480b6f7845086f4ebd787cc2f3038">show\_table\_skip\_temp\_schemas</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</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 className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_table\_show\_children</a>: If <a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a> is a schema, then <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> will return information about the tables and views in the schema, and <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">false</a> will return information about the schema itself. If <a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a> is a table or view, <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_children</a> must be <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">false</a>. If <a className="el" href="#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a> is empty, then <a className="el" href="/content/api/cpp/namespacegpudb#a2050a78788d443270f69a5e04d7f67c2">show\_children</a> must be <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a>. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a>.
          </li>

          <li>
            <a className="el" href="/content/api/cpp/namespacegpudb#a16da9c4b995d47af198c8ad820432a6c">show\_table\_get\_column\_info</a>: If <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">true</a> then column info (memory usage, etc) will be returned. Supported values:

            <ul>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#ad1805831e61943d412b1cba8ac9a35bb">show\_table\_true</a> </li>
              <li> <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a> </li>
            </ul>

            The default value is <a className="el" href="/content/api/cpp/namespacegpudb#a4269fa8dff6b16d80aa3b46b2b83ac17">show\_table\_false</a>.
          </li>
        </ul>

        <p>The default value is an empty map. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/show__table_8h_source#l00412">412</a> of file <a className="el" href="/content/api/cpp/show__table_8h_source">show\_table.h</a>.</p>
      </div>
    </div>

    <h2 className="memtitle"><span className="permalink"><a href="#a4b7e6b1e0720e0453914de2e455d9b8e">◆ </a></span>tableName</h2>

    <div className="memitem">
      <div className="memproto">
        <table className="memname">
          <tr>
            <td className="memname">std::string gpudb::ShowTableRequest::tableName</td>
          </tr>
        </table>
      </div>

      <div className="memdoc">
        <p>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>. </p>
        <p>If blank, then returns information about all tables and views. </p>
        <p className="definition">Definition at line <a className="el" href="/content/api/cpp/show__table_8h_source#l00271">271</a> of file <a className="el" href="/content/api/cpp/show__table_8h_source">show\_table.h</a>.</p>
      </div>
    </div>

    <hr />

    The documentation for this struct was generated from the following file:

    <ul>
      <li>gpudb/protocol/<a className="el" href="/content/api/cpp/show__table_8h_source">show\_table.h</a></li>
    </ul>
  </div>
</div>