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

```
URL: http://<db.host>:<db.port>/show/types
```

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.

## Input Parameter Description

<ParamField body="type_id" type="string">
  Type Id returned in response to a call to [/create/type](/content/api/rest/create_type_rest).
</ParamField>

<ParamField body="label" type="string">
  Option string that was supplied by user in a call to [/create/type](/content/api/rest/create_type_rest).
</ParamField>

<ParamField body="options" type="map of string to strings">
  Optional parameters.

  The default value is an empty map ( \{} ).

  <Expandable title="options">
    <ParamField body="no_join_types">
      When set to 'true', no join types will be included.

      The default value is `false`.

      The supported values are:

      * true
      * false
    </ParamField>
  </Expandable>
</ParamField>

## Output Parameter Description

The Kinetica server embeds the endpoint response inside a standard response structure which contains status information and the actual response to the query.  Here is a description of the various fields of the wrapper:

<ResponseField name="status" type="String">
  'OK' or 'ERROR'
</ResponseField>

<ResponseField name="message" type="String">
  Empty if success or an error message
</ResponseField>

<ResponseField name="data_type" type="String">
  'show\_types\_response' or 'none' in case of an error
</ResponseField>

<ResponseField name="data" type="String">
  Empty string
</ResponseField>

<ResponseField name="data_str" type="JSON or String">
  This embedded JSON represents the result of the /show/types endpoint:

  <Expandable title="data_str">
    <ResponseField name="type_ids" type="array of strings" />

    <ResponseField name="type_schemas" type="array of strings" />

    <ResponseField name="labels" type="array of strings" />

    <ResponseField name="properties" type="array of maps of string to arrays of strings" />

    <ResponseField name="info" type="map of string to strings">
      Additional information.
    </ResponseField>
  </Expandable>

  Empty string in case of an error.
</ResponseField>