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

> 关于表设置修改的文档

# 表设置修改

可以使用一组查询来更改表设置。你可以修改设置，也可以将其重置为默认值。单个查询可以同时更改多个设置。
如果指定名称的设置不存在，则查询会引发异常。

**语法**

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

<Note>
  这些查询仅适用于 [MergeTree](/zh/reference/engines/table-engines/mergetree-family/mergetree) 表。
</Note>

<div id="modify-setting">
  ## MODIFY SETTING
</div>

更改表设置。

**语法**

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

**示例**

```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;
```

<div id="reset-setting">
  ## RESET SETTING
</div>

将表设置重置为默认值。如果某项设置已处于默认状态，则不会执行任何操作。

**语法**

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

**示例**

```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;
```

**另请参见**

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