> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> Documentation for Table Settings Manipulations

# Table Settings Manipulations

There is a set of queries to change table settings. You can modify settings or reset them to default values. A single query can change several settings at once.
If a setting with the specified name does not exist, then the query raises an exception.

**Syntax**

```sql theme={null}
ALTER TABLE [db].name [ON CLUSTER cluster] MODIFY|RESET SETTING ...
```

<Note>
  These queries can be applied to [MergeTree](/reference/engines/table-engines/mergetree-family/mergetree) tables only.
</Note>

<h2 id="modify-setting">
  MODIFY SETTING
</h2>

Changes table settings.

**Syntax**

```sql theme={null}
MODIFY SETTING setting_name=value [, ...]
```

**Example**

```sql theme={null}
CREATE TABLE example_table (id UInt32, data String) ENGINE=MergeTree() ORDER BY id;

ALTER TABLE example_table MODIFY SETTING max_part_loading_threads=8, max_parts_in_total=50000;
```

<h2 id="reset-setting">
  RESET SETTING
</h2>

Resets table settings to their default values. If a setting is in a default state, then no action is taken.

**Syntax**

```sql theme={null}
RESET SETTING setting_name [, ...]
```

**Example**

```sql theme={null}
CREATE TABLE example_table (id UInt32, data String) ENGINE=MergeTree() ORDER BY id
    SETTINGS max_part_loading_threads=8;

ALTER TABLE example_table RESET SETTING max_part_loading_threads;
```

**See Also**

* [MergeTree settings](/reference/settings/merge-tree-settings)