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

# show_types

<div className="kinetica-pydoc">
  <div className="dl py method">
    <div className="dt sig sig-object py" id="gpudb.GPUdb.show_types"> <span className="sig-name descname"><span className="pre">show\_types</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">type\_id</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">label</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">None</span></span></span>, <span className="em sig-param"><span className="n"><span className="pre">options</span></span><span className="o"><span className="pre">=</span></span><span className="default_value"><span className="pre">{"{"}{"}"}</span></span></span><span className="sig-paren">)</span><a href="https://github.com/kineticadb/kinetica-api-python/blob/master/gpudb/gpudb.py#L40460"><span className="viewcode-link"><span className="pre">\[source]</span></span></a></div>

    <div className="dd">
      <p>Retrieves information for the specified data type ID or type label. For all data types that match the input criteria, the database returns the type ID, the type schema, the label (if available), and the type’s column properties.</p>
      <p><strong>Parameters</strong></p>

      <div className="blockquote">
        <div>
          <div className="dl">
            <div className="dt">type\_id (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>Type Id returned in response to a call to <a className="reference internal" href="#gpudb.GPUdb.create_type" title="gpudb.GPUdb.create_type"><code className="xref py py-meth docutils literal notranslate"><span className="pre">GPUdb.create\_type()</span></code></a>.</p>
            </div>

            <div className="dt">label (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>Option string that was supplied by user in a call to <a className="reference internal" href="#gpudb.GPUdb.create_type" title="gpudb.GPUdb.create_type"><code className="xref py py-meth docutils literal notranslate"><span className="pre">GPUdb.create\_type()</span></code></a>.</p>
            </div>

            <div className="dt">options (<span className="em">dict of str to str</span>) –</div>

            <div className="dd">
              <p>Optional parameters. Allowed keys are:</p>

              <ul>
                <li>
                  <p><strong>no\_join\_types</strong> – When set to ‘true’, no join types will be included. Allowed values are:</p>

                  <ul className="simple">
                    <li>
                      <p>true</p>
                    </li>

                    <li>
                      <p>false</p>
                    </li>
                  </ul>

                  <p>The default value is ‘false’.</p>
                </li>
              </ul>

              <p>The default value is an empty dict ( {"{"}{"}"} ).</p>
            </div>
          </div>
        </div>
      </div>

      <p><strong>Returns</strong></p>

      <div className="blockquote">
        <div>
          <p>A dict with the following entries–</p>

          <div className="dl simple">
            <div className="dt">type\_ids (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>The type IDs of the matching types.</p>
            </div>

            <div className="dt">type\_schemas (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>The Avro schema strings describing each matching type.</p>
            </div>

            <div className="dt">labels (<span className="em">list of str</span>) –</div>

            <div className="dd">
              <p>The user-defined labels of each matching type.</p>
            </div>

            <div className="dt">properties (<span className="em">list of dicts of str to lists of str</span>) –</div>

            <div className="dd">
              <p>The column properties of each matching type.</p>
            </div>

            <div className="dt">info (<span className="em">dict of str to str</span>) –</div>

            <div className="dd">
              <p>Additional information.</p>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>