# • SHOW TABLE SETTINGS

`SHOW TABLE SETTINGS` 是一个 SQL 语句，用于以配置文件兼容的格式显示每个表的设置。

语法如下：

```sql
SHOW TABLE index_name[.N | CHUNK N] SETTINGS
```

输出类似于 [--dumpconfig](https://vergil-lai.gitbook.io/manticoresearch-manual-zh/miscellaneous_tools#indextool) 选项中的 [indextool](https://vergil-lai.gitbook.io/manticoresearch-manual-zh/miscellaneous_tools#indextool) 实用程序。报告提供了所有表设置的详细说明，包括分词器和词典选项。

**SQL:**

```sql
SHOW TABLE forum SETTINGS;
```

```sql
+---------------+-----------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                     |
+---------------+-----------------------------------------------------------------------------------------------------------+
| settings      | min_prefix_len = 3
charset_table = 0..9, A..Z->a..z, _, -, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F |
+---------------+-----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
```

你也可以指定特定的块号以查看实时表中某个特定块的设置。编号从0开始。

**SQL:**

```sql
SHOW TABLE forum CHUNK 0 SETTINGS;
```

```sql
+---------------+-----------------------------------------------------------------------------------------------------------+
| Variable_name | Value                                                                                                     |
+---------------+-----------------------------------------------------------------------------------------------------------+
| settings      | min_prefix_len = 3
charset_table = 0..9, A..Z->a..z, _, -, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F |
+---------------+-----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
```