> ## 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-doxygen">
  <div id="ae446b45c99e9b4afa26726bce8ad23cc" />

  <h2 className="memtitle"><span className="permalink"><a href="#ae446b45c99e9b4afa26726bce8ad23cc">◆ </a></span>showTable() <span className="overload">\[1/4]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">ShowTableResponse</a> gpudb::GPUdb::showTable </td>
          <td>(</td>
          <td className="paramtype">const <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest">ShowTableRequest</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">request\_</span></span></td>
          <td>)</td>
          <td> const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Retrieves detailed information about a table, view, or schema, specified in <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a>. </p>
      <p>If the supplied <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest#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="/content/api/cpp/structgpudb_1_1ShowTableRequest#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="/content/api/cpp/structgpudb_1_1ShowTableRequest#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>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramdir">\[in]</td>
              <td className="paramname">request\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest">Request</a> object containing the parameters for the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">Response</a> object containing the result of the operation. </div>
      </div>
    </div>
  </div>

  <div id="a7335f652dfe78271639dffd37424e279" />

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

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">ShowTableResponse</a> & gpudb::GPUdb::showTable </td>
          <td>(</td>
          <td className="paramtype">const <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest">ShowTableRequest</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
        </tr>

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

          <td />

          <td className="paramtype"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">ShowTableResponse</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">response\_</span></span> ) const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Retrieves detailed information about a table, view, or schema, specified in <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest#a4b7e6b1e0720e0453914de2e455d9b8e">tableName</a>. </p>
      <p>If the supplied <a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest#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="/content/api/cpp/structgpudb_1_1ShowTableRequest#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="/content/api/cpp/structgpudb_1_1ShowTableRequest#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>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramdir">\[in]</td>
              <td className="paramname">request\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableRequest">Request</a> object containing the parameters for the operation. </td>
            </tr>

            <tr>
              <td className="paramdir">\[out]</td>
              <td className="paramname">response\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">Response</a> object containing the results of the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">Response</a> object containing the result of the operation (initially passed in by reference). </div>
      </div>
    </div>
  </div>

  <div id="a0ba64d599891431a9d2aff56dca5a9ab" />

  <h2 className="memtitle"><span className="permalink"><a href="#a0ba64d599891431a9d2aff56dca5a9ab">◆ </a></span>showTable() <span className="overload">\[3/4]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">ShowTableResponse</a> gpudb::GPUdb::showTable </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> ) const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Retrieves detailed information about a table, view, or schema, specified in <span className="em arg">tableName</span>. </p>
      <p>If the supplied <span className="em arg">tableName</span> is a schema the call can return information about either the schema itself or the tables and views it contains. If <span className="em arg">tableName</span> 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 <span className="em arg">tableName</span> 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>

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

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">Response</a> object containing the result of the operation. </div>
      </div>
    </div>
  </div>

  <div id="a9af84c2e52f527a087c8153eabb8ee89" />

  <h2 className="memtitle"><span className="permalink"><a href="#a9af84c2e52f527a087c8153eabb8ee89">◆ </a></span>showTable() <span className="overload">\[4/4]</span></h2>

  <div className="memitem">
    <div className="memproto">
      <table className="memname">
        <tr>
          <td className="memname"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">ShowTableResponse</a> & gpudb::GPUdb::showTable </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>

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

          <td />

          <td className="paramtype"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">ShowTableResponse</a> &</td>
          <td className="paramname"><span className="paramname"><span className="em">response\_</span></span> ) const</td>
        </tr>
      </table>
    </div>

    <div className="memdoc">
      <p>Retrieves detailed information about a table, view, or schema, specified in <span className="em arg">tableName</span>. </p>
      <p>If the supplied <span className="em arg">tableName</span> is a schema the call can return information about either the schema itself or the tables and views it contains. If <span className="em arg">tableName</span> 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 <span className="em arg">tableName</span> 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>

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

            <tr>
              <td className="paramdir">\[out]</td>
              <td className="paramname">response\_</td>
              <td><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">Response</a> object containing the results of the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd"><a className="el" href="/content/api/cpp/structgpudb_1_1ShowTableResponse">Response</a> object containing the result of the operation (initially passed in by reference). </div>
      </div>
    </div>
  </div>
</div>