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

<div className="kinetica-pydoc">
  <div className="dl py method">
    <div className="dt sig sig-object py" id="gpudb.GPUdb.show_schema"> <span className="sig-name descname"><span className="pre">show\_schema</span></span><span className="sig-paren">(</span><span className="em sig-param"><span className="n"><span className="pre">schema\_name</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#L39260"><span className="viewcode-link"><span className="pre">\[source]</span></span></a></div>

    <div className="dd">
      <p>Retrieves information about a <a className="reference external" href="/content/concepts/schemas/">schema</a> (or all schemas), as specified in input parameter <span className="em">schema\_name</span>.</p>
      <p><strong>Parameters</strong></p>

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

            <div className="dd">
              <p>Name of the schema for which to retrieve the information. If blank, then info for all schemas is returned.</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\_error\_if\_not\_exists</strong> – If <span className="em">false</span> will return an error if the provided input parameter <span className="em">schema\_name</span> does not exist. If <span className="em">true</span> then it will return an empty result if the provided input parameter <span className="em">schema\_name</span> does not exist. 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">schema\_name (<span className="em">str</span>) –</div>

            <div className="dd">
              <p>Value of input parameter <span className="em">schema\_name</span>.</p>
            </div>

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

            <div className="dd">
              <p>A list of all schema names for which information is returned.</p>
            </div>

            <div className="dt">schema\_tables (<span className="em">list of lists of str</span>) –</div>

            <div className="dd">
              <p>An array of arrays containing a list of tables in each of the respective output parameter <span className="em">schema\_names</span>.</p>
            </div>

            <div className="dt">additional\_info (<span className="em">list of dicts of str to str</span>) –</div>

            <div className="dd">
              <p>Additional information about the respective tables in output parameter <span className="em">schema\_names</span>.</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>