> ## 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/tables/bytype

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

Gets names of the tables whose type matches the given criteria. Each table has
a particular type. This type comprises the schema and properties of the table
and sometimes a type label. This function allows a look up of the existing
tables based on full or partial type information. The operation is synchronous.

## Input Parameter Description

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

<ParamField body="label" type="string">
  Optional user supplied label which can be used instead of the type\_id to retrieve all tables with the given label.
</ParamField>

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

  The default value is an empty map ( \{} ).
</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\_tables\_by\_type\_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/tables/bytype endpoint:

  <Expandable title="data_str">
    <ResponseField name="table_names" type="array of strings">
      List of tables matching the input criteria.
    </ResponseField>

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

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