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

# showTypes

<div className="kinetica-doxygen">
  <div id="a0fc586ac75575b833a0927011cf78487" />

  <h2 className="memtitle"><span className="permalink"><a href="#a0fc586ac75575b833a0927011cf78487">◆ </a></span>showTypes() <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"><a className="el" href="/content/api/cs/classkinetica_1_1ShowTypesResponse">ShowTypesResponse</a> kinetica.Kinetica.showTypes </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1ShowTypesRequest">ShowTypesRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></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>Retrieves information for the specified data type ID or type label. </p>
      <p>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>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request 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">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L63072">63072</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a4b90766503e86da30175c7ea63ae808b" />

  <h2 className="memtitle"><span className="permalink"><a href="#a4b90766503e86da30175c7ea63ae808b">◆ </a></span>showTypes() <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"><a className="el" href="/content/api/cs/classkinetica_1_1ShowTypesResponse">ShowTypesResponse</a> kinetica.Kinetica.showTypes </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">type\_id</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">label</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</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>Retrieves information for the specified data type ID or type label. </p>
      <p>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>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">type\_id</td>
              <td>Type Id returned in response to a call to <a className="el" href="#a5e541ff6a7d69768408cef650af603b3">createType</a>.</td>
            </tr>

            <tr>
              <td className="paramname">label</td>
              <td>Option string that was supplied by user in a call to <a className="el" href="#a5e541ff6a7d69768408cef650af603b3">createType</a>.</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#a230306c30aaffe836087bac568ea87f6">NO\_JOIN\_TYPES</a>: When set to 'true', no join types will be included. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#adf403b10ba0ea67ebb76ad86f1b57213">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#a533d37ab86d2361fb1964f1d1aa817ab">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#a533d37ab86d2361fb1964f1d1aa817ab">FALSE</a>.
                  </li>
                </ul>

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

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Response object containing the result of the operation. </div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L63155">63155</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="a27ce63c2447a4b2cb9ea4655add290b1" />

  <h2 className="memtitle"><span className="permalink"><a href="#a27ce63c2447a4b2cb9ea4655add290b1">◆ </a></span>ShowTypesAsync() <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">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1ShowTypesResponse">ShowTypesResponse</a> > kinetica.Kinetica.ShowTypesAsync </td>
                <td>(</td>
                <td className="paramtype"><a className="el" href="/content/api/cs/classkinetica_1_1ShowTypesRequest">ShowTypesRequest</a></td>
                <td className="paramname"><span className="paramname"><span className="em">request\_</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</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>Retrieves information for the specified data type ID or type label. </p>
      <p>(async) </p>
      <p>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>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">request\_</td>
              <td>Request object containing the parameters for the operation.</td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L63100">63100</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>

  <div id="acd9f584daddf076642b23f6950456717" />

  <h2 className="memtitle"><span className="permalink"><a href="#acd9f584daddf076642b23f6950456717">◆ </a></span>ShowTypesAsync() <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">async System.Threading.Tasks.Task\< <a className="el" href="/content/api/cs/classkinetica_1_1ShowTypesResponse">ShowTypesResponse</a> > kinetica.Kinetica.ShowTypesAsync </td>
                <td>(</td>
                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">type\_id</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">string</td>
                <td className="paramname"><span className="paramname"><span className="em">label</span></span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">IDictionary\< string, string ></td>
                <td className="paramname"><span className="paramname"><span className="em">options</span></span><span className="paramdefsep"> = </span><span className="paramdefval">null</span>, </td>
              </tr>

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

                <td />

                <td className="paramtype">System.Threading.CancellationToken</td>
                <td className="paramname"><span className="paramname"><span className="em">cancellationToken</span></span><span className="paramdefsep"> = </span><span className="paramdefval">default</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>Retrieves information for the specified data type ID or type label. </p>
      <p>(async) </p>
      <p>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>

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

        <div className="dd">
          <table className="params">
            <tr>
              <td className="paramname">type\_id</td>
              <td>Type Id returned in response to a call to <a className="el" href="#a5e541ff6a7d69768408cef650af603b3">createType</a>.</td>
            </tr>

            <tr>
              <td className="paramname">label</td>
              <td>Option string that was supplied by user in a call to <a className="el" href="#a5e541ff6a7d69768408cef650af603b3">createType</a>.</td>
            </tr>

            <tr>
              <td className="paramname">options</td>

              <td>
                Optional parameters.

                <ul>
                  <li>
                    <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#a230306c30aaffe836087bac568ea87f6">NO\_JOIN\_TYPES</a>: When set to 'true', no join types will be included. Supported values:

                    <ul>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#adf403b10ba0ea67ebb76ad86f1b57213">TRUE</a> </li>
                      <li> <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#a533d37ab86d2361fb1964f1d1aa817ab">FALSE</a> </li>
                    </ul>

                    The default value is <a className="el" href="/content/api/cs/structkinetica_1_1ShowTypesRequest_1_1Options#a533d37ab86d2361fb1964f1d1aa817ab">FALSE</a>.
                  </li>
                </ul>

                The default value is an empty Dictionary.
              </td>
            </tr>

            <tr>
              <td className="paramname">cancellationToken</td>
              <td>Cancellation token to cancel the operation.</td>
            </tr>
          </table>
        </div>
      </div>

      <div className="dl section return">
        <div className="dt">Returns</div>
        <div className="dd">Task that returns the response object containing the result of the operation.</div>
      </div>

      <p className="definition">Definition at line <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs#L63202">63202</a> of file <a className="el" href="https://github.com/kineticadb/kinetica-api-cs/blob/master/Kinetica/KineticaFunctions.cs">KineticaFunctions.cs</a>.</p>
    </div>
  </div>
</div>