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

### show\_tables\_by\_type

<ul>
  <li>
    show\_tables\_by\_type(\
    &#x20;type\_id: string,\
    &#x20;label: string,\
    &#x20;options?: Record\<string, string>,\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md),\
    ): Promise\<[ShowTablesByTypeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/ShowTablesByTypeResponse.md)>

    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.

    #### Parameters

    <ul>
      <li>
        type\_id: string

        Type id returned by a call to `create_type`.
      </li>

      <li>
        label: string

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

      <li>
        `Optional`options: Record\<string, string>

        Optional parameters.
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[ShowTablesByTypeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/ShowTablesByTypeResponse.md)>

    Promise\<Types.ShowTablesByTypeResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:14420](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L14420)</li>
    </ul>
  </li>
</ul>

### show\_tables\_by\_type\_request

<ul>
  <li>
    show\_tables\_by\_type\_request(\
    &#x20;request: [ShowTablesByTypeRequest](https://docs.kinetica.com/content/api/javascript/interfaces/ShowTablesByTypeRequest.md),\
    &#x20;callback?: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md),\
    ): Promise\<[ShowTablesByTypeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/ShowTablesByTypeResponse.md)>

    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.

    #### Parameters

    <ul>
      <li>
        request: [ShowTablesByTypeRequest](https://docs.kinetica.com/content/api/javascript/interfaces/ShowTablesByTypeRequest.md)

        Request object containing the parameters for the operation
      </li>

      <li>
        `Optional`callback: [GPUdbCallback](https://docs.kinetica.com/content/api/javascript/types/GPUdbCallback.md)

        Optional callback function
      </li>
    </ul>

    #### Returns Promise\<[ShowTablesByTypeResponse](https://docs.kinetica.com/content/api/javascript/interfaces/ShowTablesByTypeResponse.md)>

    Promise\<Types.ShowTablesByTypeResponse> - Promise resolving to the response

    <ul>
      <li>Defined in [src/GPUdb.ts:14391](https://github.com/kineticadb/kinetica-api-typescript/blob/master/src/GPUdb.ts#L14391)</li>
    </ul>
  </li>
</ul>


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.