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

# DynamicSchemaData

> DynamicSchemaData — Kinetica TypeScript API

Decoded payload of an endpoint that returns a dynamic schema, such as execute\_sql or aggregate\_group\_by.Always present on the responses that declare it: the client decodes the payload on every such response before handing it back, so consumers never need to guard the field.A statement that returns no result set -- DDL such as CREATE TABLE ... AS SELECT -- still carries the field, but with no columns: read `count_affected` for those rather than `column_headers`.The values are column-major, not a list of records: `column_1` holds every value for the column named by `column_headers[0]`, `column_2` for `column_headers[1]`, and so on.

#### Example

```
const response = await gpudb.execute_sql('SELECT category FROM t', 0, 10, '', [], {});
const data = response.data;
// data.column_headers -> ['category']
// data.column_1       -> ['A', 'B']
```

interface DynamicSchemaData \{\
&#x20;[column\_datatypes](#column_datatypes): string\[];\
&#x20;[column\_headers](#column_headers): string\[];\
&#x20;\[column: string]: any;\
}

#### Indexable

<ul>
  <li>
    \[column: string]: any

    Column values, keyed `column_1` through `column_N`
  </li>
</ul>

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

##### Index

### Properties

[column\_datatypes](#column_datatypes) [column\_headers](#column_headers)&#x20;

## Properties

### column\_datatypes

column\_datatypes: string\[]

Data type of each column, in order

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

### column\_headers

column\_headers: string\[]

Name of each column, in order

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


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