You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by ji...@apache.org on 2022/10/24 11:45:17 UTC
[shardingsphere] branch master updated: Update DistSQL documents (#21721)
This is an automated email from the ASF dual-hosted git repository.
jianglongtao pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/shardingsphere.git
The following commit(s) were added to refs/heads/master by this push:
new b1242fa2d3d Update DistSQL documents (#21721)
b1242fa2d3d is described below
commit b1242fa2d3dea648d433c78d133e13c416e0850d
Author: Zichao <57...@users.noreply.github.com>
AuthorDate: Tue Oct 25 00:45:10 2022 +1300
Update DistSQL documents (#21721)
---
.../syntax/rdl/resource-definition/_index.cn.md | 7 --
.../syntax/rdl/resource-definition/_index.en.md | 7 --
.../rdl/resource-definition/add-resource.cn.md | 107 -------------------
.../rdl/resource-definition/add-resource.en.md | 110 --------------------
.../rdl/resource-definition/alter-resource.cn.md | 109 --------------------
.../rdl/resource-definition/alter-resource.en.md | 112 --------------------
.../rdl/resource-definition/drop-resource.cn.md | 58 -----------
.../rdl/resource-definition/drop-resource.en.md | 61 -----------
.../rdl/storage-unit-definition/_index.cn.md | 7 ++
.../rdl/storage-unit-definition/_index.en.md | 7 ++
.../alter-storage-unit.cn.md | 109 ++++++++++++++++++++
.../alter-storage-unit.en.md | 112 ++++++++++++++++++++
.../register-storage-unit.cn.md | 107 +++++++++++++++++++
.../register-storage-unit.en.md | 110 ++++++++++++++++++++
.../unregister-storage-unit.cn.md | 58 +++++++++++
.../unregister-storage-unit.en.md | 61 +++++++++++
.../distsql/syntax/rql/resource-query/_index.cn.md | 7 --
.../distsql/syntax/rql/resource-query/_index.en.md | 7 --
.../resource-query/show-database-resources.cn.md | 67 ------------
.../resource-query/show-database-resources.en.md | 67 ------------
.../resource-query/show-rules-used-resource.cn.md | 66 ------------
.../resource-query/show-rules-used-resource.en.md | 66 ------------
.../rql/resource-query/show-unused-resource.cn.md | 65 ------------
.../rql/resource-query/show-unused-resource.en.md | 65 ------------
.../rule-query/shadow/show-shadow-algorithm.cn.md | 75 ++++++++++++++
.../rule-query/shadow/show-shadow-algorithm.en.md | 76 ++++++++++++++
.../single-table/show-single-table.cn.md | 108 ++++++++++++++++++++
.../single-table/show-single-table.en.md | 107 +++++++++++++++++++
.../syntax/rql/storage-unit-query/_index.cn.md | 7 ++
.../syntax/rql/storage-unit-query/_index.en.md | 7 ++
.../storage-unit-query/show-storage-units.cn.md | 113 +++++++++++++++++++++
.../storage-unit-query/show-storage-units.en.md | 109 ++++++++++++++++++++
32 files changed, 1173 insertions(+), 981 deletions(-)
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/_index.cn.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/_index.cn.md
deleted file mode 100644
index 39ff4ece3c7..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/_index.cn.md
+++ /dev/null
@@ -1,7 +0,0 @@
-+++
-title = "资源定义"
-weight = 1
-chapter = true
-+++
-
-本章节将对资源定义的语法进行详细说明。
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/_index.en.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/_index.en.md
deleted file mode 100644
index b6096f4a10d..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/_index.en.md
+++ /dev/null
@@ -1,7 +0,0 @@
-+++
-title = "Resource Definition"
-weight = 1
-chapter = true
-+++
-
-This chapter describes the syntax of resource definition.
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/add-resource.cn.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/add-resource.cn.md
deleted file mode 100644
index 0ad58e29bc1..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/add-resource.cn.md
+++ /dev/null
@@ -1,107 +0,0 @@
-+++
-title = "ADD RESOURCE"
-weight = 2
-+++
-
-### 描述
-
-`ADD RESOURCE` 语法用于为当前所选逻辑库（DATABASE）添加资源。
-
-### 语法
-
-```sql
-AddResource ::=
- 'ADD' 'RESOURCE' resourceDefinition (',' resourceDefinition)*
-
-resourceDefinition ::=
- resourceName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
-
-resourceName ::=
- identifier
-
-hostname ::=
- string
-
-port ::=
- int
-
-dbName ::=
- string
-
-url ::=
- string
-
-user ::=
- string
-
-password ::=
- string
-
-proerties ::=
- PROPERTIES '(' property ( ',' property )* ')'
-
-property ::=
- key '=' value
-
-key ::=
- string
-
-value ::=
- string
-```
-
-### 特别说明
-
-- 添加资源前请确认已经在 Proxy 中创建逻辑数据库，并执行 `use` 命令成功选择一个逻辑数据库；
-- 确认添加的资源是可以正常连接的， 否则将不能添加成功；
-- `resourceName` 区分大小写；
-- `resourceName` 在当前逻辑库中需要唯一；
-- `resourceName` 命名只允许使用字母、数字以及 `_` ，且必须以字母开头；
-- `poolProperty` 用于自定义连接池参数，`key` 必须和连接池参数名一致，`value` 支持 int 和 String 类型；
-- 当 `password` 包含特殊字符时，建议使用 string 形式；例如 `password@123`的 string 形式为 `"password@123"`。
-
-### 示例
-
-- 使用标准模式添加资源
-
-```sql
-ADD RESOURCE ds_0 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_0,
- USER=root,
- PASSWORD=root
-);
-```
-
-- 使用标准模式添加资源并设置连接池参数
-
-```sql
-ADD RESOURCE ds_1 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_1,
- USER=root,
- PASSWORD=root,
- PROPERTIES("maximumPoolSize"=10)
-);
-```
-
-- 使用 URL 模式添加资源并设置连接池参数
-
-```sql
-ADD RESOURCE ds_2 (
- URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
- USER=root,
- PASSWORD=root,
- PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
-);
-```
-
-### 保留字
-
-`ADD`、`RESOURCE`、`HOST`、`PORT`、`DB`、`USER`、`PASSWORD`、`PROPERTIES`、`URL`
-
-### 相关链接
-
-- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/add-resource.en.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/add-resource.en.md
deleted file mode 100644
index 019a3e4a9d9..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/add-resource.en.md
+++ /dev/null
@@ -1,110 +0,0 @@
-+++
-title = "ADD RESOURCE"
-weight = 2
-+++
-
-### Description
-
-The `ADD RESOURCE` syntax is used to add resources for the currently selected database.
-
-### Syntax
-
-```sql
-AddResource ::=
- 'ADD' 'RESOURCE' resourceDefinition (',' resourceDefinition)*
-
-resourceDefinition ::=
- resourceName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
-
-resourceName ::=
- identifier
-
-hostname ::=
- string
-
-port ::=
- int
-
-dbName ::=
- string
-
-url ::=
- string
-
-user ::=
- string
-
-password ::=
- string
-
-proerties ::=
- PROPERTIES '(' property ( ',' property )* ')'
-
-property ::=
- key '=' value
-
-key ::=
- string
-
-value ::=
- string
-```
-
-### Supplement
-
-- Before adding resources, please confirm that a database has been created in Proxy, and execute the `use` command to
- successfully select a database;
-- Confirm that the added resource can be connected normally, otherwise it will not be added successfully;
-- `resourceName` is case-sensitive;
-- `resourceName` needs to be unique within the current database;
-- `resourceName` name only allows letters, numbers and `_`, and must start with a letter;
-- `poolProperty` is used to customize connection pool parameters, `key` must be the same as the connection pool
- parameter name, `value` supports int and String types;
-- When `password` contains special characters, it is recommended to use the string form; For example, the string form
- of `password@123` is `"password@123"`.
-
-### Example
-
-- Add resource using standard mode
-
-```sql
-ADD RESOURCE ds_0 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_0,
- USER=root,
- PASSWORD=root
-);
-```
-
-- Add resource and set connection pool parameters using standard mode
-
-```sql
-ADD RESOURCE ds_1 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_1,
- USER=root,
- PASSWORD=root,
- PROPERTIES("maximumPoolSize"=10)
-);
-```
-
-- Add resource and set connection pool parameters using URL patterns
-
-```sql
-ADD RESOURCE ds_2 (
- URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
- USER=root,
- PASSWORD=root,
- PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
-);
-```
-
-### Reserved word
-
-`ADD`, `RESOURCE`, `HOST`, `PORT`, `DB`, `USER`, `PASSWORD`, `PROPERTIES`, `URL`
-
-### Related links
-
-- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/alter-resource.cn.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/alter-resource.cn.md
deleted file mode 100644
index 937d8f4d9d9..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/alter-resource.cn.md
+++ /dev/null
@@ -1,109 +0,0 @@
-+++
-title = "ALTER RESOURCE"
-weight = 3
-+++
-
-### 描述
-
-`ALTER RESOURCE` 语法用于修改当前所选逻辑库（DATABASE）的资源。
-
-### 语法
-
-```sql
-AlterResource ::=
- 'ALTER' 'RESOURCE' resourceDefinition (',' resourceDefinition)*
-
-resourceDefinition ::=
- resourceName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
-
-resourceName ::=
- identifier
-
-hostname ::=
- string
-
-port ::=
- int
-
-dbName ::=
- string
-
-url ::=
- string
-
-user ::=
- string
-
-password ::=
- string
-
-proerties ::=
- PROPERTIES '(' property ( ',' property )* ')'
-
-property ::=
- key '=' value
-
-key ::=
- string
-
-value ::=
- string
-```
-
-### 补充说明
-
-- 修改资源前请确认已经在 Proxy 中创建逻辑数据库，并执行 `use` 命令成功选择一个逻辑数据库；
-- `ALTER RESOURCE`不允许改变该资源关联的真实数据源；
-- `ALTER RESOURCE`会发生连接池的切换，这个操作可能对进行中的业务造成影响，请谨慎使用；
-- 确认添加的资源是可以正常连接的， 否则将不能添加成功；
-- `resourceName` 区分大小写；
-- `resourceName` 在当前逻辑库中需要唯一；
-- `resourceName` 命名只允许使用字母、数字以及 `_` ，且必须以字母开头；
-- `poolProperty` 用于自定义连接池参数，`key` 必须和连接池参数名一致，`value` 支持 int 和 String 类型；
-- 当 `password` 包含特殊字符时，建议使用 string 形式；例如 `password@123`的 string 形式为 `"password@123"`。
-
-### 示例
-
-- 使用标准模式修改资源
-
-```sql
-ALTER RESOURCE ds_0 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_0,
- USER=root,
- PASSWORD=root
-);
-```
-
-- 使用标准模式修改资源并设置连接池参数
-
-```sql
-ALTER RESOURCE ds_1 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_1,
- USER=root,
- PASSWORD=root,
- PROPERTIES("maximumPoolSize"=10)
-);
-```
-
-- 使用 URL 模式修改资源并设置连接池参数
-
-```sql
-ALTER RESOURCE ds_2 (
- URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
- USER=root,
- PASSWORD=root,
- PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
-);
-```
-
-### 保留字
-
-`ALTER`、`RESOURCE`、`HOST`、`PORT`、`DB`、`USER`、`PASSWORD`、`PROPERTIES`、`URL`
-
-### 相关链接
-
-- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/alter-resource.en.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/alter-resource.en.md
deleted file mode 100644
index 03a09b2c107..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/alter-resource.en.md
+++ /dev/null
@@ -1,112 +0,0 @@
-+++
-title = "ALTER RESOURCE"
-weight = 3
-+++
-
-### Description
-
-The `ALTER RESOURCE` syntax is used to alter resources for the currently selected database.
-
-### Syntax
-
-```sql
-AlterResource ::=
- 'ALTER' 'RESOURCE' resourceDefinition (',' resourceDefinition)*
-
-resourceDefinition ::=
- resourceName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
-
-resourceName ::=
- identifier
-
-hostname ::=
- string
-
-port ::=
- int
-
-dbName ::=
- string
-
-url ::=
- string
-
-user ::=
- string
-
-password ::=
- string
-
-proerties ::=
- PROPERTIES '(' property ( ',' property )* ')'
-
-property ::=
- key '=' value
-
-key ::=
- string
-
-value ::=
- string
-```
-
-### Supplement
-
-- Before altering the resources, please confirm that a database exists in Proxy, and execute the `use` command to
- successfully select a database;
-- `ALTER RESOURCE` is not allowed to change the real data source associated with this resource;
-- `ALTER RESOURCE` will switch the connection pool. This operation may affect the ongoing business, please use it with
- caution;
-- `resourceName` is case-sensitive;
-- `resourceName` needs to be unique within the current database;
-- `resourceName` name only allows letters, numbers and `_`, and must start with a letter;
-- `poolProperty` is used to customize connection pool parameters, `key` must be the same as the connection pool
- parameter name, `value` supports int and String types;
-- When `password` contains special characters, it is recommended to use the string form; for example, the string form
- of `password@123` is `"password@123"`.
-
-### Example
-
-- Alter resource using standard mode
-
-```sql
-ALTER RESOURCE ds_0 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_0,
- USER=root,
- PASSWORD=root
-);
-```
-
-- Alter resource and set connection pool parameters using standard mode
-
-```sql
-ALTER RESOURCE ds_1 (
- HOST=127.0.0.1,
- PORT=3306,
- DB=db_1,
- USER=root,
- PASSWORD=root
- PROPERTIES("maximumPoolSize"=10)
-);
-```
-
-- Alter resource and set connection pool parameters using URL patterns
-
-```sql
-ALTER RESOURCE ds_2 (
- URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
- USER=root,
- PASSWORD=root,
- PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
-);
-```
-
-### Reserved word
-
-`ALTER`, `RESOURCE`, `HOST`, `PORT`, `DB`, `USER`, `PASSWORD`, `PROPERTIES`, `URL`
-
-### Related links
-
-- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/drop-resource.cn.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/drop-resource.cn.md
deleted file mode 100644
index d65f3449a3c..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/drop-resource.cn.md
+++ /dev/null
@@ -1,58 +0,0 @@
-+++
-title = "DROP RESOURCE"
-weight = 4
-+++
-
-### 描述
-
-`DROP RESOURCE` 语法用于从当前逻辑库中移除资源。
-
-### 语法
-
-```sql
-DropResource ::=
- 'DROP' 'RESOURCE' ( 'IF' 'EXISTS' )? resourceName ( ',' resourceName )* ( 'IGNORE' 'SINGLE' 'TABLES' )?
-
-resourceName ::=
- identifier
-```
-
-### 补充说明
-
-- `DROP RESOURCE` 只会移除 Proxy 中的资源，不会删除与资源对应的真实数据源；
-- 无法移除已经被规则使用的资源。移除被规则使用的资源时会提示 `Resources are still in used`；
-- 将要移除的资源中仅包含 `SINGLE TABLE RULE`，且用户确认可以忽略该限制时，可添加 `IGNORE SINGLE TABLES` 关键字移除资源。
-
-### 示例
-
-- 移除资源
-
-```sql
-DROP RESOURCE ds_0;
-```
-
-- 移除多个资源
-
-```sql
-DROP RESOURCE ds_1, ds_2;
-```
-
-- 忽略单表移除资源
-
-```sql
-DROP RESOURCE ds_3 IGNORE SINGLE TABLES;
-```
-
-- 如果资源存在则移除
-
-```sql
-DROP RESOURCE IF EXISTS ds_4;
-```
-
-### 保留字
-
-`DROP`、`RESOURCE`、`IF`、`EXISTS`、`IGNORE`、`SINGLE`、`TABLES`
-
-### 相关链接
-
-- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/drop-resource.en.md b/docs/document/content/reference/distsql/syntax/rdl/resource-definition/drop-resource.en.md
deleted file mode 100644
index dcef7cda59b..00000000000
--- a/docs/document/content/reference/distsql/syntax/rdl/resource-definition/drop-resource.en.md
+++ /dev/null
@@ -1,61 +0,0 @@
-+++
-title = "DROP RESOURCE"
-weight = 4
-+++
-
-### Description
-
-The `DROP RESOURCE` syntax is used to drop resources from the current database
-
-### Syntax
-
-```sql
-DropResource ::=
- 'DROP' 'RESOURCE' ( 'IF' 'EXISTS' )? resourceName ( ',' resourceName )* ( 'IGNORE' 'SINGLE' 'TABLES' )?
-
-resourceName ::=
- identifier
-```
-
-### Supplement
-
-- `DROP RESOURCE` will only drop resources in Proxy, the real data source corresponding to the resource will not be
- dropped;
-- Unable to drop resources already used by rules. `Resources are still in used.` will be prompted when removing
- resources used by rules;
-- The resource need to be removed only contains `SINGLE TABLE RULE`, and when the user confirms that this restriction
- can be ignored, the `IGNORE SINGLE TABLES` keyword can be added to remove the resource.
-
-### Example
-
-- Drop a resource
-
-```sql
-DROP RESOURCE ds_0;
-```
-
-- Drop multiple resources
-
-```sql
-DROP RESOURCE ds_1, ds_2;
-```
-
-- Ignore single table rule remove resource
-
-```sql
-DROP RESOURCE ds_1 IGNORE SINGLE TABLES;
-```
-
-- Drop the resource if it exists
-
-```sql
-DROP RESOURCE IF EXISTS ds_2;
-```
-
-### Reserved word
-
-`DROP`, `RESOURCE`, `IF`, `EXISTS`, `IGNORE`, `SINGLE`, `TABLES`
-
-### Related links
-
-- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/_index.cn.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/_index.cn.md
new file mode 100644
index 00000000000..d3027eeb99c
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/_index.cn.md
@@ -0,0 +1,7 @@
++++
+title = "存储单元定义"
+weight = 1
+chapter = true
++++
+
+本章节将对存储单元定义的语法进行详细说明。
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/_index.en.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/_index.en.md
new file mode 100644
index 00000000000..fd4754320e1
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/_index.en.md
@@ -0,0 +1,7 @@
++++
+title = "Storage Unit Definition"
+weight = 1
+chapter = true
++++
+
+This chapter describes the syntax of storage unit.
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit.cn.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit.cn.md
new file mode 100644
index 00000000000..d8dcecb11cc
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit.cn.md
@@ -0,0 +1,109 @@
++++
+title = "ALTER STORAGE UNIT"
+weight = 3
++++
+
+### 描述
+
+`ALTER STORAGE UNIT` 语法用于修改当前所选逻辑库（DATABASE）的存储单元。
+
+### 语法
+
+```sql
+AlterResource ::=
+ 'ALTER' 'STORAGE' 'UNIT' storageUnitDefinition (',' storageUnitDefinition)*
+
+storageUnitDefinition ::=
+ storageUnitName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
+
+storageUnitName ::=
+ identifier
+
+hostname ::=
+ string
+
+port ::=
+ int
+
+dbName ::=
+ string
+
+url ::=
+ string
+
+user ::=
+ string
+
+password ::=
+ string
+
+proerties ::=
+ PROPERTIES '(' property ( ',' property )* ')'
+
+property ::=
+ key '=' value
+
+key ::=
+ string
+
+value ::=
+ string
+```
+
+### 补充说明
+
+- 修改存储单元前请确认已经在 Proxy 中创建逻辑数据库，并执行 `use` 命令成功选择一个逻辑数据库；
+- `ALTER STORAGE UNIT`不允许改变该存储单元关联的真实数据源；
+- `ALTER STORAGE UNIT`会发生连接池的切换，这个操作可能对进行中的业务造成影响，请谨慎使用；
+- 确认添加的存储单元是可以正常连接的， 否则将不能添加成功；
+- `storageUnitName` 区分大小写；
+- `storageUnitName` 在当前逻辑库中需要唯一；
+- `storageUnitName` 命名只允许使用字母、数字以及 `_` ，且必须以字母开头；
+- `poolProperty` 用于自定义连接池参数，`key` 必须和连接池参数名一致，`value` 支持 int 和 String 类型；
+- 当 `password` 包含特殊字符时，建议使用 string 形式；例如 `password@123`的 string 形式为 `"password@123"`。
+
+### 示例
+
+- 使用标准模式修改存储单元
+
+```sql
+ALTER STORAGE UNIT su_0 (
+ HOST="127.0.0.1",
+ PORT=3306,
+ DB="db_0",
+ USER="root",
+ PASSWORD="root"
+);
+```
+
+- 使用标准模式修改存储单元并设置连接池参数
+
+```sql
+ALTER STORAGE UNIT su_1 (
+ HOST="127.0.0.1",
+ PORT=3306,
+ DB="db_1",
+ USER="root",
+ PASSWORD="root",
+ PROPERTIES("maximumPoolSize"=10)
+);
+```
+
+- 使用 URL 模式修改存储单元并设置连接池参数
+
+```sql
+ALTER STORAGE UNIT su_2 (
+ URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
+ USER="root",
+ PASSWORD="root",
+ PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
+);
+```
+
+### 保留字
+
+`ALTER`、`STORAGE`、`UNIT`、`HOST`、`PORT`、`DB`、`USER`、`PASSWORD`、`PROPERTIES`、`URL`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit.en.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit.en.md
new file mode 100644
index 00000000000..80365637c0b
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/alter-storage-unit.en.md
@@ -0,0 +1,112 @@
++++
+title = "ALTER STORAGE UNIT"
+weight = 3
++++
+
+### Description
+
+The `ALTER STORAGE UNIT` syntax is used to alter storage units for the currently selected logical database.
+
+### Syntax
+
+```sql
+AlterResource ::=
+ 'ALTER' 'STORAGE' 'UNIT' storageUnitDefinition (',' storageUnitDefinition)*
+
+storageUnitDefinition ::=
+ storageUnitName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
+
+storageUnitName ::=
+ identifier
+
+hostname ::=
+ string
+
+port ::=
+ int
+
+dbName ::=
+ string
+
+url ::=
+ string
+
+user ::=
+ string
+
+password ::=
+ string
+
+proerties ::=
+ PROPERTIES '(' property ( ',' property )* ')'
+
+property ::=
+ key '=' value
+
+key ::=
+ string
+
+value ::=
+ string
+```
+
+### Supplement
+
+- Before altering the storage units, please confirm that a database exists in Proxy, and execute the `use` command to
+ successfully select a database;
+- `ALTER STORAGE UNIT` is not allowed to change the real data source associated with this storageUnit;
+- `ALTER STORAGE UNIT` will switch the connection pool. This operation may affect the ongoing business, please use it with
+ caution;
+- `storageUnitName` is case-sensitive;
+- `storageUnitName` needs to be unique within the current database;
+- `storageUnitName` name only allows letters, numbers and `_`, and must start with a letter;
+- `poolProperty` is used to customize connection pool parameters, `key` must be the same as the connection pool
+ parameter name, `value` supports int and String types;
+- When `password` contains special characters, it is recommended to use the string form; for example, the string form
+ of `password@123` is `"password@123"`.
+
+### Example
+
+- Alter storage unit using standard mode
+
+```sql
+ALTER STORAGE UNIT su_0 (
+ HOST=127.0.0.1,
+ PORT=3306,
+ DB=db_0,
+ USER=root,
+ PASSWORD=root
+);
+```
+
+- Alter storage unit and set connection pool parameters using standard mode
+
+```sql
+ALTER STORAGE UNIT su_1 (
+ HOST=127.0.0.1,
+ PORT=3306,
+ DB=db_1,
+ USER=root,
+ PASSWORD=root
+ PROPERTIES("maximumPoolSize"=10)
+);
+```
+
+- Alter storage unit and set connection pool parameters using URL patterns
+
+```sql
+ALTER STORAGE UNIT su_2 (
+ URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
+ USER=root,
+ PASSWORD=root,
+ PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
+);
+```
+
+### Reserved word
+
+`ALTER`, `STORAGE`, `UNIT`, `HOST`, `PORT`, `DB`, `USER`, `PASSWORD`, `PROPERTIES`, `URL`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/register-storage-unit.cn.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/register-storage-unit.cn.md
new file mode 100644
index 00000000000..bb59802de61
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/register-storage-unit.cn.md
@@ -0,0 +1,107 @@
++++
+title = "REGISTER STORAGE UNIT"
+weight = 2
++++
+
+### 描述
+
+`REGISTER STORAGE UNIT` 语法用于为当前所选逻辑库（DATABASE）注册存储单元。
+
+### 语法
+
+```sql
+RegisterStorageUnit ::=
+ 'REGISTER' 'STORAGE' 'UNIT' storageUnitDefinition (',' storageUnitDefinition)*
+
+storageUnitDefinition ::=
+ StorageUnitName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
+
+storageUnitName ::=
+ identifier
+
+hostname ::=
+ string
+
+port ::=
+ int
+
+dbName ::=
+ string
+
+url ::=
+ string
+
+user ::=
+ string
+
+password ::=
+ string
+
+proerties ::=
+ PROPERTIES '(' property ( ',' property )* ')'
+
+property ::=
+ key '=' value
+
+key ::=
+ string
+
+value ::=
+ string
+```
+
+### 特别说明
+
+- 注册存储单元前请确认已经在 Proxy 中创建逻辑数据库，并执行 `use` 命令成功选择一个逻辑数据库；
+- 确认注册的存储单元是可以正常连接的， 否则将不能注册成功；
+- `storageUnitName` 区分大小写；
+- `storageUnitName` 在当前逻辑库中需要唯一；
+- `storageUnitName` 命名只允许使用字母、数字以及 `_` ，且必须以字母开头；
+- `poolProperty` 用于自定义连接池参数，`key` 必须和连接池参数名一致，`value` 支持 int 和 String 类型；
+- 当 `password` 包含特殊字符时，建议使用 string 形式；例如 `password@123`的 string 形式为 `"password@123"`。
+
+### 示例
+
+- 使用标准模式注册存储单元
+
+```sql
+REGISTER STORAGE UNIT su_0 (
+ HOST="127.0.0.1",
+ PORT=3306,
+ DB="db_0",
+ USER="root",
+ PASSWORD="root"
+);
+```
+
+- 使用标准模式注册存储单元并设置连接池参数
+
+```sql
+REGISTER STORAGE UNIT su_1 (
+ HOST="127.0.0.1",
+ PORT=3306,
+ DB="db_1",
+ USER="root",
+ PASSWORD="root",
+ PROPERTIES("maximumPoolSize"=10)
+);
+```
+
+- 使用 URL 模式注册存储单元并设置连接池参数
+
+```sql
+REGISTER STORAGE UNIT su_2 (
+ URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
+ USER="root",
+ PASSWORD="root",
+ PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
+);
+```
+
+### 保留字
+
+`REGISTER`、`STORAGE`、`UNIT`、`HOST`、`PORT`、`DB`、`USER`、`PASSWORD`、`PROPERTIES`、`URL`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/register-storage-unit.en.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/register-storage-unit.en.md
new file mode 100644
index 00000000000..13d7606e74c
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/register-storage-unit.en.md
@@ -0,0 +1,110 @@
++++
+title = "REGISTER STORAGE UNIT"
+weight = 2
++++
+
+### Description
+
+The `REGISTER STORAGE UNIT` syntax is used to register storage unit for the currently selected logical database.
+
+### Syntax
+
+```sql
+RegisterStorageUnit ::=
+ 'REGISTER' 'STORAGE' 'UNIT' storageUnitDefinition (',' storageUnitDefinition)*
+
+storageUnitDefinition ::=
+ StorageUnitName '(' ( 'HOST' '=' hostName ',' 'PORT' '=' port ',' 'DB' '=' dbName | 'URL' '=' url ) ',' 'USER' '=' user (',' 'PASSWORD' '=' password )? (',' proerties)?')'
+
+storageUnitName ::=
+ identifier
+
+hostname ::=
+ string
+
+port ::=
+ int
+
+dbName ::=
+ string
+
+url ::=
+ string
+
+user ::=
+ string
+
+password ::=
+ string
+
+proerties ::=
+ PROPERTIES '(' property ( ',' property )* ')'
+
+property ::=
+ key '=' value
+
+key ::=
+ string
+
+value ::=
+ string
+```
+
+### Supplement
+
+- Before register storage units, please confirm that a database has been created in Proxy, and execute the `use` command to
+ successfully select a database;
+- Confirm that the registered storage unit can be connected normally, otherwise it will not be added successfully;
+- `storageUnitName` is case-sensitive;
+- `storageUnitName` needs to be unique within the current database;
+- `storageUnitName` name only allows letters, numbers and `_`, and must start with a letter;
+- `poolProperty` is used to customize connection pool parameters, `key` must be the same as the connection pool
+ parameter name, `value` supports int and String types;
+- When `password` contains special characters, it is recommended to use the string form; For example, the string form
+ of `password@123` is `"password@123"`.
+
+### Example
+
+- Register storage unit using standard mode
+
+```sql
+REGISTER STORAGE UNIT su_1 (
+ HOST="127.0.0.1",
+ PORT=3306,
+ DB="db_1",
+ USER="root",
+ PASSWORD="root"
+);
+```
+
+- Register storage unit and set connection pool parameters using standard mode
+
+```sql
+REGISTER STORAGE UNIT su_1 (
+ HOST="127.0.0.1",
+ PORT=3306,
+ DB="db_1",
+ USER="root",
+ PASSWORD="root",
+ PROPERTIES("maximumPoolSize"=10)
+);
+```
+
+- Register storage unit and set connection pool parameters using URL patterns
+
+```sql
+REGISTER STORAGE UNIT su_2 (
+ URL="jdbc:mysql://127.0.0.1:3306/db_2?serverTimezone=UTC&useSSL=false",
+ USER="root",
+ PASSWORD="root",
+ PROPERTIES("maximumPoolSize"=10,"idleTimeout"="30000")
+);
+```
+
+### Reserved word
+
+`REGISTER`, `STORAGE`, `UNIT`, `HOST`, `PORT`, `DB`, `USER`, `PASSWORD`, `PROPERTIES`, `URL`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit.cn.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit.cn.md
new file mode 100644
index 00000000000..ffebf9e9abf
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit.cn.md
@@ -0,0 +1,58 @@
++++
+title = "UNREGISTER STORAGE UNIT"
+weight = 4
++++
+
+### 描述
+
+`UNREGISTER STORAGE UNIT` 语法用于从当前逻辑库中移除存储单元。
+
+### 语法
+
+```sql
+UnregisterStorageUnit ::=
+ 'DROP' 'STORAGE' 'UNIT' ( 'IF' 'EXISTS' )? storageUnitName ( ',' storageUnitName )* ( 'IGNORE' 'SINGLE' 'TABLES' )?
+
+storageUnitName ::=
+ identifier
+```
+
+### 补充说明
+
+- `UNREGISTER STORAGE UNIT` 只会移除 Proxy 中的存储单元，不会删除与存储单元对应的真实数据源；
+- 无法移除已经被规则使用的存储单元。移除被规则使用的存储单元时会提示 `Storage unit are still in used`；
+- 将要移除的存储单元中仅包含 `SINGLE TABLE RULE`，且用户确认可以忽略该限制时，可添加 `IGNORE SINGLE TABLES` 关键字移除存储单元。
+
+### 示例
+
+- 移除存储单元
+
+```sql
+UNREGISTER STORAGE UNIT su_0;
+```
+
+- 移除多个存储单元
+
+```sql
+UNREGISTER STORAGE UNIT su_1, su_2;
+```
+
+- 忽略单表移除存储单元
+
+```sql
+UNREGISTER STORAGE UNIT su_3 IGNORE SINGLE TABLES;
+```
+
+- 如果存储单元存在则移除
+
+```sql
+UNREGISTER STORAGE UNIT IF EXISTS su_4;
+```
+
+### 保留字
+
+`DROP`、`STORAGE`、`UNIT`、`IF`、`EXISTS`、`IGNORE`、`SINGLE`、`TABLES`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit.en.md b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit.en.md
new file mode 100644
index 00000000000..3ef4e8b3fa5
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rdl/storage-unit-definition/unregister-storage-unit.en.md
@@ -0,0 +1,61 @@
++++
+title = "UNREGISTER STORAGE UNIT"
+weight = 4
++++
+
+### Description
+
+The `UNREGISTER STORAGE UNIT` syntax is used to unregister storage unit from the current database
+
+### Syntax
+
+```sql
+UnregisterStorageUnit ::=
+ 'DROP' 'STORAGE' 'UNIT' ( 'IF' 'EXISTS' )? storageUnitName ( ',' storageUnitName )* ( 'IGNORE' 'SINGLE' 'TABLES' )?
+
+storageUnitName ::=
+ identifier
+```
+
+### Supplement
+
+- `UNREGISTER STORAGE UNIT` will only unregister storage unit in Proxy, the real data source corresponding to the storage unit will not be
+ dropped;
+- Unable to unregister storage unit already used by rules. `Storage unit are still in used.` will be prompted when removing
+ storage units used by rules;
+- The storage unit need to be removed only contains `SINGLE TABLE RULE`, and when the user confirms that this restriction
+ can be ignored, the `IGNORE SINGLE TABLES` keyword can be added to remove the storage unit.
+
+### Example
+
+- Drop a storage unit
+
+```sql
+UNREGISTER STORAGE UNIT su_0;
+```
+
+- Drop multiple storage units
+
+```sql
+UNREGISTER STORAGE UNIT su_1, su_2;
+```
+
+- Ignore single table rule remove storage unit
+
+```sql
+UNREGISTER STORAGE UNIT su_1 IGNORE SINGLE TABLES;
+```
+
+- Drop the storage unit if it exists
+
+```sql
+UNREGISTER STORAGE UNIT IF EXISTS su_2;
+```
+
+### Reserved word
+
+`DROP`, `STORAGE`, `UNIT`, `IF`, `EXISTS`, `IGNORE`, `SINGLE`, `TABLES`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/_index.cn.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/_index.cn.md
deleted file mode 100644
index eb5a47fbfb3..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/_index.cn.md
+++ /dev/null
@@ -1,7 +0,0 @@
-+++
-title = "资源查询"
-weight = 1
-chapter = true
-+++
-
-本章节将对资源查询的语法进行详细说明。
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/_index.en.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/_index.en.md
deleted file mode 100644
index aa82cbc1281..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/_index.en.md
+++ /dev/null
@@ -1,7 +0,0 @@
-+++
-title = "Resource Query"
-weight = 1
-chapter = true
-+++
-
-This chapter describes the syntax of resource query.
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-database-resources.cn.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/show-database-resources.cn.md
deleted file mode 100644
index 6cd11746604..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-database-resources.cn.md
+++ /dev/null
@@ -1,67 +0,0 @@
-+++
-title = "SHOW DATABASE RESOURCES"
-weight = 2
-+++
-
-### 描述
-
-`SHOW DATABASE RESOURCES` 语法用于查询指定逻辑库已经添加的资源。
-
-### 语法
-
-```sql
-ShowResource ::=
- 'SHOW' 'DATABASE' 'RESOURCES' ('FROM' databaseName)?
-
-databaseName ::=
- identifier
-```
-
-### 特别说明
-
-- 未指定 `databaseName` 时，默认是当前使用的 `DATABASE`； 如未使用 `DATABASE` 则会提示 `No database selected`。
-
-### 返回值说明
-
-| 列 | 说明 |
-| --------- | -------- |
-| name | 数据源名称 |
-| type | 数据源类型 |
-| host | 数据源地址 |
-| port | 数据源端口 |
-| db | 数据库名称 |
-| attribute | 数据源参数 |
-
-### 示例
-
-- 查询指定逻辑库的资源
-
-```sql
-SHOW DATABASE RESOURCES FROM sharding_db;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db_1 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-2 rows in set (0.26 sec)
-```
-
-- 查询当前逻辑库的资源
-
-```sql
-SHOW DATABASE RESOURCES;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db_1 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-2 rows in set (0.26 sec)
-```
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-database-resources.en.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/show-database-resources.en.md
deleted file mode 100644
index 233f9c89c70..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-database-resources.en.md
+++ /dev/null
@@ -1,67 +0,0 @@
-+++
-title = "SHOW DATABASE RESOURCES"
-weight = 2
-+++
-
-### Description
-
-The `SHOW DATABASE RESOURCES` syntax is used to query the resources that have been added to the specified database.
-
-### Syntax
-
-```sql
-ShowResource ::=
- 'SHOW' 'DATABASE' 'RESOURCES' ('FROM' databaseName)?
-
-databaseName ::=
- identifier
-```
-
-### Supplement
-
-- When `databaseName` is not specified, the default is the currently used `DATABASE`; if `DATABASE` is not used, it will prompt `No database selected`.
-
-### Return Value Description
-
-| Column | Description |
-| --------- | --------------------- |
-| name | Data source name |
-| type | Data source type |
-| host | Data source host |
-| port | Data source port |
-| db | Database name |
-| attribute | Data source attribute |
-
- ### Example
-
-- Query resources for the specified database
-
-```sql
-SHOW DATABASE RESOURCES FROM sharding_db;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db_1 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-2 rows in set (0.26 sec)
-```
-
-- Query resources for the current database
-
-```sql
-SHOW DATABASE RESOURCES;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-| ds_1 | MySQL | 127.0.0.1 | 3306 | db_1 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-2 rows in set (0.26 sec)
-```
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-rules-used-resource.cn.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/show-rules-used-resource.cn.md
deleted file mode 100644
index 1931a68288e..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-rules-used-resource.cn.md
+++ /dev/null
@@ -1,66 +0,0 @@
-+++
-title = "SHOW RULES USED RESOURCE"
-weight = 4
-+++
-
-### 描述
-
-`SHOW RULES USED RESOURCE` 语法用于查询指定逻辑库中使用指定资源的规则。
-
-### 语法
-
-```sql
-showRulesUsedResource ::=
- 'SHOW' 'RULES' 'USED' 'RESOURCES' resourceName ('FROM' databaseName)?
-
-resourceName ::=
- IDENTIFIER | STRING
-
-databaseName ::=
- IDENTIFIER
-```
-
-### 特别说明
-
-- 未指定 `databaseName` 时, 默认是当前使用的 `DATABASE`； 如未使用 `DATABASE` 则会提示 `No database selected`。
-
-### 返回值说明
-
-| 列 | 说明 |
-| --------- | --------- |
-| type | 特性 |
-| name | 数据源名称 |
-
-### 示例
-
-- 查询指定逻辑库中使用指定资源的规则
-
-```sql
-SHOW RULES USED RESOURCE ds_0 FROM sharding_db;
-```
-
-```sql
-+----------+--------------+
-| type | name |
-+----------+--------------+
-| sharding | t_order |
-| sharding | t_order_item |
-+----------+--------------+
-2 rows in set (0.00 sec)
-```
-
-- 查询当前逻辑库中使用指定资源的规则
-
-```sql
-SHOW RULES USED RESOURCE ds_0;
-```
-
-```sql
-+----------+--------------+
-| type | name |
-+----------+--------------+
-| sharding | t_order |
-| sharding | t_order_item |
-+----------+--------------+
-2 rows in set (0.00 sec)
-```
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-rules-used-resource.en.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/show-rules-used-resource.en.md
deleted file mode 100644
index baebe50448e..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-rules-used-resource.en.md
+++ /dev/null
@@ -1,66 +0,0 @@
-+++
-title = "SHOW RULES USED RESOURCE"
-weight = 4
-+++
-
-### Description
-
-The `SHOW RULES USED RESOURCE` syntax is used to query the rules that use the specified resource in the specified database.
-
-### Syntax
-
-```sql
-showRulesUsedResource ::=
- 'SHOW' 'RULES' 'USED' 'RESOURCES' resourceName ('FROM' databaseName)?
-
-resourceName ::=
- IDENTIFIER | STRING
-
-databaseName ::=
- IDENTIFIER
-```
-
-### Supplement
-
-- When `databaseName` is not specified, the default is the currently used `DATABASE`; if `DATABASE` is not used, it will prompt `No database selected`.
-
-### Return Value Description
-
-| Column | Description |
-| --------- | --------------------- |
-| type | features |
-| name | Data source name |
-
-### Example
-
-- Query the rules that use the specified resource in the specified database
-
-```sql
-SHOW RULES USED RESOURCE ds_0 FROM sharding_db;
-```
-
-```sql
-+----------+--------------+
-| type | name |
-+----------+--------------+
-| sharding | t_order |
-| sharding | t_order_item |
-+----------+--------------+
-2 rows in set (0.00 sec)
-```
-
-- Query the rules that use the specified resource in the current database
-
-```sql
-SHOW RULES USED RESOURCE ds_0;
-```
-
-```sql
-+----------+--------------+
-| type | name |
-+----------+--------------+
-| sharding | t_order |
-| sharding | t_order_item |
-+----------+--------------+
-2 rows in set (0.00 sec)
-```
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-unused-resource.cn.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/show-unused-resource.cn.md
deleted file mode 100644
index 3ca4eefb8c8..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-unused-resource.cn.md
+++ /dev/null
@@ -1,65 +0,0 @@
-+++
-title = "SHOW UNUSED RESOURCE"
-weight = 3
-+++
-
-### 描述
-
-`SHOW UNUSED RESOURCE` 语法用于查询指定逻辑库中还未被规则引用的资源。
-
-### 语法
-
-```sql
-ShowUnusedResource ::=
- 'SHOW' 'UNUSED' 'DATABASE'? 'RESOURCES' ('FROM' databaseName)?
-
-databaseName ::=
- identifier
-```
-
-### 特别说明
-
-- 未指定 `databaseName` 时，默认是当前使用的 `DATABASE`； 如未使用 `DATABASE` 则会提示 `No database selected`。
-
-### 返回值说明
-
-| 列 | 说明 |
-| --------- | -------- |
-| name | 数据源名称 |
-| type | 数据源类型 |
-| host | 数据源地址 |
-| port | 数据源端口 |
-| db | 数据库名称 |
-| attribute | 数据源参数 |
-
- ### 示例
-
-- 查询指定逻辑库的资源
-
-```sql
-SHOW UNUSED DATABASE RESOURCES FROM sharding_db;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-1 rows in set (0.26 sec)
-```
-
-- 查询当前逻辑库的资源
-
-```sql
-SHOW UNUSED DATABASE RESOURCES;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-1 rows in set (0.26 sec)
-```
diff --git a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-unused-resource.en.md b/docs/document/content/reference/distsql/syntax/rql/resource-query/show-unused-resource.en.md
deleted file mode 100644
index 47545a2bdd6..00000000000
--- a/docs/document/content/reference/distsql/syntax/rql/resource-query/show-unused-resource.en.md
+++ /dev/null
@@ -1,65 +0,0 @@
-+++
-title = "SHOW UNUSED RESOURCE"
-weight = 3
-+++
-
-### Description
-
-The `SHOW UNUSED RESOURCE` syntax is used to query resources in the specified database that have not been referenced by rules.
-
-### Syntax
-
-```sql
-ShowUnusedResource ::=
- 'SHOW' 'UNUSED' 'DATABASE'? 'RESOURCES' ('FROM' databaseName)?
-
-databaseName ::=
- identifier
-```
-
-### Supplement
-
-- When `databaseName` is not specified, the default is the currently used `DATABASE`; if `DATABASE` is not used, it will prompt `No database selected`.
-
-### Return Value Description
-
-| Column | Description |
-| --------- | --------------------- |
-| name | Data source name |
-| type | Data source type |
-| host | Data source host |
-| port | Data source port |
-| db | Database name |
-| attribute | Data source attribute |
-
-### Example
-
-- Query resources for the specified database
-
-```sql
-SHOW UNUSED DATABASE RESOURCES FROM sharding_db;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-1 rows in set (0.26 sec)
-```
-
-- Query resources for the current database
-
-```sql
-SHOW UNUSED DATABASE RESOURCES;
-```
-
-```sql
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-| ds_0 | MySQL | 127.0.0.1 | 3306 | db_0 | 30000 | 60000 | 1800000 | 50 | 1 | false | {"dataSourceProperties":{"cacheServerConfiguration":"true","elideSetAutoCommits":"true","useServerPrepStmts":"true","cachePrepStmts":"true","rewriteBatchedStatements":"true","cacheResultSetMetadata":"false","useLocalSessionState":"true","maintainTimeStats":"false","prepStmtCacheSize":"200000","tinyInt1isBit":"fals [...]
-+------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
-1 rows in set (0.26 sec)
-```
diff --git a/docs/document/content/reference/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm.cn.md b/docs/document/content/reference/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm.cn.md
new file mode 100644
index 00000000000..813351707e0
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm.cn.md
@@ -0,0 +1,75 @@
++++
+title = "SHOW SHADOW ALGORITHM"
+weight = 4
++++
+
+### 描述
+
+`SHOW SHADOW ALGORITHM` 语法用于查询指定逻辑库中的影子算法。
+
+### 语法
+
+```
+ShowEncryptAlgorithm::=
+ 'SHOW' 'SHADOW' 'ALGORITHMS' ('FROM' databaseName)?
+
+databaseName ::=
+ identifier
+```
+
+### 补充说明
+
+- 未指定 `databaseName` 时，默认是当前使用的 `DATABASE`。 如果也未使用 `DATABASE` 则会提示 `No database selected`。
+
+### 返回值说明
+
+| 列 | 说明 |
+| ------------------- | ---------- |
+| shadow_algorithm_name | 影子算法名称 |
+| type | 算法类型 |
+| props | 算法参数 |
+| is_default | 是否默认 |
+
+### 示例
+
+- 查询指定逻辑库中的影子算法
+
+```sql
+SHOW SHADOW ALGORITHMS FROM test1;
+```
+
+```sql
+mysql> SHOW SHADOW ALGORITHMS FROM test1;
++-------------------------+-------------+-----------------------------------------+------------+
+| shadow_algorithm_name | type | props | is_default |
++-------------------------+-------------+-----------------------------------------+------------+
+| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false |
++-------------------------+-------------+-----------------------------------------+------------+
+1 row in set (0.00 sec)
+```
+
+- 查询当前逻辑库中的影子算法
+
+```sql
+SHOW SHADOW ALGORITHMS;
+```
+
+```sql
+mysql> SHOW SHADOW ALGORITHMS;
++-------------------------+-------------+-----------------------------------------+------------+
+| shadow_algorithm_name | type | props | is_default |
++-------------------------+-------------+-----------------------------------------+------------+
+| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false |
++-------------------------+-------------+-----------------------------------------+------------+
+1 row in set (0.00 sec)
+```
+
+
+### 保留字
+
+`SHOW`、`SHADOW`、`ALGORITHMS`、`FROM`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
+
diff --git a/docs/document/content/reference/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm.en.md b/docs/document/content/reference/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm.en.md
new file mode 100644
index 00000000000..94524dc584a
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/rule-query/shadow/show-shadow-algorithm.en.md
@@ -0,0 +1,76 @@
++++
+title = "SHOW SHADOW ALGORITHM"
+weight = 4
++++
+
+### Description
+
+The `SHOW SHADOW ALGORITHM` syntax is used to query shadow algorithms for specified database.
+
+### Syntax
+
+```
+ShowEncryptAlgorithm::=
+ 'SHOW' 'SHADOW' 'ALGORITHMS' ('FROM' databaseName)?
+
+databaseName ::=
+ identifier
+```
+
+### Supplement
+
+- When `databaseName` is not specified, the default is the currently used `DATABASE`. If `DATABASE` is not used, `No database selected` will be prompted.
+
+### Return value description
+
+| Column | Description |
+| --------------------- | --------------------------- |
+| shadow_algorithm_name | Shadow algorithm name |
+| type | Shadow algorithm type |
+| props | Shadow algorithm properties |
+| is_default | Default |
+
+
+
+
+### Example
+
+- Query shadow algorithms for specified database.
+
+```sql
+SHOW SHADOW ALGORITHMS FROM test1;
+```
+
+```sql
+mysql> SHOW SHADOW ALGORITHMS FROM test1;
++-------------------------+-------------+-----------------------------------------+------------+
+| shadow_algorithm_name | type | props | is_default |
++-------------------------+-------------+-----------------------------------------+------------+
+| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false |
++-------------------------+-------------+-----------------------------------------+------------+
+1 row in set (0.00 sec)
+```
+
+- Query shadow algorithms for current database.
+
+```sql
+SHOW SHADOW ALGORITHMS;
+```
+
+```sql
+mysql> SHOW SHADOW ALGORITHMS;
++-------------------------+-------------+-----------------------------------------+------------+
+| shadow_algorithm_name | type | props | is_default |
++-------------------------+-------------+-----------------------------------------+------------+
+| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false |
++-------------------------+-------------+-----------------------------------------+------------+
+1 row in set (0.00 sec)
+```
+
+### Reserved word
+
+`SHOW`, `SHADOW`, `ALGORITHMS`, `FROM`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rql/rule-query/single-table/show-single-table.cn.md b/docs/document/content/reference/distsql/syntax/rql/rule-query/single-table/show-single-table.cn.md
new file mode 100644
index 00000000000..feb62818187
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/rule-query/single-table/show-single-table.cn.md
@@ -0,0 +1,108 @@
++++
+title = "SHOW SINGLE TABLE"
+weight = 3
++++
+
+### 描述
+
+`SHOW SINGLE TABLE` 语法用于查询指定逻辑库中的单表。
+
+### 语法
+
+```
+ShowSingleTable::=
+ 'SHOW' 'SINGLE' ('TABLES'|'TABLE' tableName) ('FROM' databaseName)?
+
+tableName ::=
+ identifier
+
+databaseName ::=
+ identifier
+```
+
+### 补充说明
+
+- 未指定 `databaseName` 时，默认是当前使用的 `DATABASE`。 如果也未使用 `DATABASE` 则会提示 `No database selected`。
+
+### 返回值说明
+
+| 列 | 说明 |
+| ------------- | -------------------- |
+| table_name | 单表名称 |
+| resource_name | 单表所在的数据源名称 |
+
+
+### 示例
+
+- 查询指定逻辑库中的指定单表
+
+```sql
+SHOW SINGLE TABLE t_user FROM test1;
+```
+
+```sql
+mysql> SHOW SINGLE TABLE t_user FROM test1;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+- 查询当前逻辑库中的指定单表
+
+```sql
+SHOW SINGLE TABLE t_user;
+```
+
+```sql
+mysql> SHOW SINGLE TABLE t_user;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+- 查询指定逻辑库中的单表
+
+```sql
+SHOW SINGLE TABLES FROM test1;
+```
+
+```sql
+mysql> SHOW SINGLE TABLES FROM test1;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+- 查询当前逻辑库中的单表
+
+```sql
+SHOW SINGLE TABLES;
+```
+
+```sql
+mysql> SHOW SINGLE TABLES;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+### 保留字
+
+`SHOW`、`SINGLE`、`TABLE`、`TABLES`、`FROM`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
+
diff --git a/docs/document/content/reference/distsql/syntax/rql/rule-query/single-table/show-single-table.en.md b/docs/document/content/reference/distsql/syntax/rql/rule-query/single-table/show-single-table.en.md
new file mode 100644
index 00000000000..052dee19b8b
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/rule-query/single-table/show-single-table.en.md
@@ -0,0 +1,107 @@
++++
+title = "SHOW SINGLE TABLE"
+weight = 2
++++
+
+### Description
+
+The `SHOW SINGLE TABLE` syntax is used to query single tables for specified database.
+
+### Syntax
+
+```
+ShowSingleTable::=
+ 'SHOW' 'SINGLE' ('TABLES'|'TABLE' tableName) ('FROM' databaseName)?
+
+tableName ::=
+ identifier
+
+databaseName ::=
+ identifier
+```
+
+### Supplement
+
+- When `databaseName` is not specified, the default is the currently used `DATABASE`. If `DATABASE` is not used, `No database selected` will be prompted.
+
+### Return value description
+
+| Column | Description |
+| ------------- | ------------------------------------------------------|
+| table_name | Single table name |
+| resource_name | The resource name where the single table is located |
+
+
+### Example
+
+- Query specified single table for specified database.
+
+```sql
+SHOW SINGLE TABLE t_user FROM test1;
+```
+
+```sql
+mysql> SHOW SINGLE TABLE t_user FROM test1;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+- Query specified single table for current database.
+
+```sql
+SHOW SINGLE TABLE t_user;
+```
+
+```sql
+mysql> SHOW SINGLE TABLE t_user;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+- Query single tables for specified database.
+
+```sql
+SHOW SINGLE TABLES FROM test1;
+```
+
+```sql
+mysql> SHOW SINGLE TABLES FROM test1;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+- Query single tables for current database.
+
+```sql
+SHOW SINGLE TABLES;
+```
+
+```sql
+mysql> SHOW SINGLE TABLES;
++------------+---------------+
+| table_name | resource_name |
++------------+---------------+
+| t_user | ds_0 |
++------------+---------------+
+1 row in set (0.00 sec)
+```
+
+### Reserved word
+
+`SHOW`, `SINGLE`, `TABLE`, `TABLES`, `FROM`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git a/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/_index.cn.md b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/_index.cn.md
new file mode 100644
index 00000000000..a2dc6e78719
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/_index.cn.md
@@ -0,0 +1,7 @@
++++
+title = "存储单元查询"
+weight = 1
+chapter = true
++++
+
+本章节将对存储单元查询的语法进行详细说明。
diff --git a/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/_index.en.md b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/_index.en.md
new file mode 100644
index 00000000000..2fd88f08c04
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/_index.en.md
@@ -0,0 +1,7 @@
++++
+title = "Storage Unit Query"
+weight = 1
+chapter = true
++++
+
+This chapter describes the syntax of storage unit query.
diff --git a/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/show-storage-units.cn.md b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/show-storage-units.cn.md
new file mode 100644
index 00000000000..f969f3c9400
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/show-storage-units.cn.md
@@ -0,0 +1,113 @@
++++
+title = "SHOW STORAGE UNITS"
+weight = 2
++++
+
+### 描述
+
+`SHOW STORAGE UNITS` 语法用于查询指定逻辑库已经注册的存储单元。
+
+### 语法
+
+```sql
+ShowStorageUnit ::=
+ 'SHOW' 'STORAGE' 'UNITS' ('WHERE' 'USAGE_COUNT' '=' usageCount)? ('FROM' databaseName)?
+
+usageCount ::=
+ int
+
+databaseName ::=
+ identifier
+```
+
+### 特别说明
+
+- 未指定 `databaseName` 时，默认是当前使用的 `DATABASE`； 如未使用 `DATABASE` 则会提示 `No database selected`。
+
+### 返回值说明
+
+| 列 | 说明 |
+| --------- | ---------- |
+| name | 存储单元名称 |
+| type | 存储单元类型 |
+| host | 存储单元地址 |
+| port | 存储单元端口 |
+| db | 数据库名称 |
+| attribute | 存储单元参数 |
+
+### 示例
+
+- 查询指定逻辑库中未被使用的存储单元
+
+```sql
+SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM test1;
+```
+
+```sql
+mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM test1;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.03 sec)
+```
+
+- 查询当前逻辑库中未被使用的存储单元
+
+```sql
+SHOW STORAGE UNITS WHERE USAGE_COUNT = 0;
+```
+
+```sql
+mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT=0;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.01 sec)
+```
+
+- 查询指定逻辑库的存储单元
+
+```sql
+SHOW STORAGE UNITS FROM test1;
+```
+
+```sql
+mysql> SHOW STORAGE UNITS FROM test1;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.01 sec)
+```
+
+- 查询当前逻辑库的存储单元
+
+```sql
+SHOW STORAGE UNITS;
+```
+
+```sql
+mysql> SHOW STORAGE UNITS;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.00 sec)
+```
+### 保留字
+
+`SHOW`、`STORAGE`、`UNITS`、`WHERE`、`USAGE_COUNT`、`FROM`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git a/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/show-storage-units.en.md b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/show-storage-units.en.md
new file mode 100644
index 00000000000..ad0ae19c5f6
--- /dev/null
+++ b/docs/document/content/reference/distsql/syntax/rql/storage-unit-query/show-storage-units.en.md
@@ -0,0 +1,109 @@
++++
+title = "SHOW STORAGE UNITS"
+weight = 2
++++
+
+### Description
+
+The `SHOW STORAGE UNITS` syntax is used to query the storage units that have been added to the specified database.
+
+### Syntax
+
+```sql
+ShowStorageUnit ::=
+ 'SHOW' 'STORAGE' 'UNITS' ('FROM' databaseName)?
+
+databaseName ::=
+ identifier
+```
+
+### Supplement
+
+- When `databaseName` is not specified, the default is the currently used `DATABASE`; if `DATABASE` is not used, it will prompt `No database selected`.
+
+### Return Value Description
+
+| Column | Description |
+| --------- | --------------------- |
+| name | Storage unit name |
+| type | Storage unit type |
+| host | Storage unit host |
+| port | Storage unit port |
+| db | Database name |
+| attribute | Storage unit attribute|
+
+ ### Example
+
+- Query unused storage units for the specified database
+
+```sql
+SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM test1;
+```
+
+```
+mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT = 0 FROM test1;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.03 sec)
+```
+
+- Query unused storage units for current database
+
+```sql
+SHOW STORAGE UNITS WHERE USAGE_COUNT = 0;
+```
+
+```sql
+mysql> SHOW STORAGE UNITS WHERE USAGE_COUNT=0;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.01 sec)
+```
+- Query storage units for the specified database
+
+```sql
+SHOW STORAGE UNITS FROM test1;
+```
+
+```sql
+mysql> SHOW STORAGE UNITS FROM test1;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.01 sec)
+```
+
+- Query storage units for the current database
+
+```sql
+SHOW STORAGE UNITS;
+```
+
+```sql
+mysql> SHOW STORAGE UNITS;
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| name | type | host | port | db | connection_timeout_milliseconds | idle_timeout_milliseconds | max_lifetime_milliseconds | max_pool_size | min_pool_size | read_only | other_attributes [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+| su_1 | MySQL | 127.0.0.1 | 3306 | db1 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
+| su_0 | MySQL | 127.0.0.1 | 3306 | db0 | 30000 | 60000 | 2100000 | 50 | 1 | false | {"dataSourceProperties":{"maintainTimeStats":"false","rewriteBatchedStatements":"true","tinyInt1isBit":"false","cacheResultSetMetadata":"false","useServerPrepStmts":"true","netTimeoutForStreamingResults":"0","useSSL":"false","prepStmtCacheSqlLimit":"2048","elideSetAutoCommits":"true","cachePrepStmts":"true","serve [...]
++------+-------+-----------+------+------+---------------------------------+---------------------------+---------------------------+---------------+---------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [...]
+2 rows in set (0.00 sec)
+```
+### Reserved word
+
+`SHOW`, `STORAGE`, `UNIT`, `WHERE`, `USAGE_COUNT`, `FROM`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
\ No newline at end of file