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

# /clear/tables

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

Clears (drops) tables in the database cluster. The operation is synchronous
meaning that the tables will be cleared before the function returns. The
response payload returns the status of the operation for each table requested.

## Input Parameter Description

<ParamField body="table_names" type="array of strings">
  Names of the tables to be cleared, in \[schema\_name.]table\_name format, using standard [name resolution rules](../../concepts/tables/#table-name-resolution). Must be existing tables. Empty list clears all available tables, though this behavior is be prevented by default via gpudb.conf parameter 'disable\_clear\_all'.

  The default value is an empty array ( \[] ).
</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_error_if_not_exists">
      If *true* and if a table specified in input parameter *table\_names* does not exist no error is returned. If *false* and if a table specified in input parameter *table\_names* does not exist then an error is returned.

      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">
  'clear\_tables\_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 /clear/tables endpoint:

  <Expandable title="data_str">
    <ResponseField name="tables" type="map of string to strings">
      For each table in input parameter *table\_names*, any error from the clear operation, or an empty string if successful.
    </ResponseField>

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

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