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

# /check/table

```
URL: http://<db.host>:<db.port>/check/table
```

Scans the requested tables as specified in input parameter *table\_names* for
integrity. Any table chunks which fail the check will be marked as corrupt. By
default the database will automatically repair corrupt tables (via truncating).
Note that since this reads every table column from disk it may be a potentially
long-running operation. The option *local\_only* can be used to skip any table
files already written to a remote storage. Returns table corruption results.

## Input Parameter Description

<ParamField body="table_names" type="array of strings">
  List of tables to query. An asterisk returns all tables.
</ParamField>

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

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

  <Expandable title="options">
    <ParamField body="local_only">
      If *true* only locally persisted files will be checked.

      The default value is `false`.

      The supported values are:

      * true
      * false
    </ParamField>

    <ParamField body="show_detail">
      If *true* reports individual chunk errors.

      The default value is `true`.

      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">
  'check\_table\_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 /check/table endpoint:

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

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

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

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

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

      The default value is an empty map ( \{} ).
    </ResponseField>
  </Expandable>

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