This is an automated email from the ASF dual-hosted git repository.
zhangliang 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 e6b42f3dae6 add distsql rdl alter and drop default single table rule
doc. (#21094)
e6b42f3dae6 is described below
commit e6b42f3dae608a4be2de5ea0ccf0606cbcc574e2
Author: tianhao960 <[email protected]>
AuthorDate: Sun Sep 25 20:08:22 2022 +0800
add distsql rdl alter and drop default single table rule doc. (#21094)
* add distsql rdl alter and drop default single table rule doc.
* fix typo
---
.../alter-default-single-table-rule.cn.md | 41 ++++++++++++++++++++++
.../alter-default-single-table-rule.en.md | 41 ++++++++++++++++++++++
.../drop-default-single-table-rule.cn.md | 34 ++++++++++++++++++
.../drop-default-single-table-rule.en.md | 35 ++++++++++++++++++
4 files changed, 151 insertions(+)
diff --git
a/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/alter-default-single-table-rule.cn.md
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/alter-default-single-table-rule.cn.md
new file mode 100644
index 00000000000..8fa2ec210fa
--- /dev/null
+++
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/alter-default-single-table-rule.cn.md
@@ -0,0 +1,41 @@
++++
+title = "ALTER DEFAULT SINGLE TABLE RULE"
+weight = 2
++++
+
+## 描述
+
+`ALTER DEFAULT SINGLE TABLE RULE` 语法用于修改默认的单表规则
+
+### 语法定义
+
+```sql
+AlterDefaultSingleTableRule ::=
+ 'ALTER' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' singleTableDefinition
+
+singleTableDefinition ::=
+ 'RESOURCE' '=' resourceName
+
+resourceName ::=
+ identifier
+```
+
+### 补充说明
+
+- `RESOURCE` 需使用 RDL 管理的数据源资源。
+
+### 示例
+
+#### 修改默认单表规则
+
+```sql
+ALTER DEFAULT SINGLE TABLE RULE RESOURCE = ds_0;
+```
+
+### 保留字
+
+`ALTER`、`SHARDING`、`SINGLE`、`TABLE`、`RULE`、`RESOURCE`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git
a/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/alter-default-single-table-rule.en.md
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/alter-default-single-table-rule.en.md
new file mode 100644
index 00000000000..62cb452f0de
--- /dev/null
+++
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/alter-default-single-table-rule.en.md
@@ -0,0 +1,41 @@
++++
+title = "ALTER DEFAULT SINGLE TABLE RULE"
+weight = 2
++++
+
+## Description
+
+The `ALTER DEFAULT SINGLE TABLE RULE` syntax is used to alter a default single
table rule.
+
+### Syntax
+
+```sql
+AlterDefaultSingleTableRule ::=
+ 'ALTER' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' singleTableDefinition
+
+singleTableDefinition ::=
+ 'RESOURCE' '=' resourceName
+
+resourceName ::=
+ identifier
+```
+
+### Supplement
+
+- `RESOURCE` needs to use data source resource managed by RDL.
+
+### Example
+
+#### Alter a default single table rule
+
+```sql
+ALTER DEFAULT SINGLE TABLE RULE RESOURCE = ds_0;
+```
+
+### Reserved word
+
+`ALTER`, `SHARDING`, `SINGLE`, `TABLE`, `RULE`, `RESOURCE`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)
diff --git
a/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/drop-default-single-table-rule.cn.md
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/drop-default-single-table-rule.cn.md
new file mode 100644
index 00000000000..8a28c1a599b
--- /dev/null
+++
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/drop-default-single-table-rule.cn.md
@@ -0,0 +1,34 @@
++++
+title = "DROP DEFAULT SINGLE TABLE RULE"
+weight = 2
++++
+
+## 描述
+
+`DROP DEFAULT SINGLE TABLE RULE` 语法用于删除默认的单表规则
+
+### 语法定义
+
+```sql
+DropDefaultSingleTableRule ::=
+ 'DROP' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' ifExists?
+
+ifExists ::=
+ 'IF' 'EXISTS'
+```
+
+### 示例
+
+#### 删除默认单表规则
+
+```sql
+DROP DEFAULT SINGLE TABLE RULE;
+```
+
+### 保留字
+
+`DROP`、`SHARDING`、`SINGLE`、`TABLE`、`RULE`
+
+### 相关链接
+
+- [保留字](/cn/reference/distsql/syntax/reserved-word/)
\ No newline at end of file
diff --git
a/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/drop-default-single-table-rule.en.md
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/drop-default-single-table-rule.en.md
new file mode 100644
index 00000000000..69d33212454
--- /dev/null
+++
b/docs/document/content/reference/distsql/syntax/rdl/rule-definition/single-table/drop-default-single-table-rule.en.md
@@ -0,0 +1,35 @@
++++
+title = "DROP DEFAULT SINGLE TABLE RULE"
+weight = 2
++++
+
+## Description
+
+The `DROP DEFAULT SINGLE TABLE RULE` syntax is used to drop a default single
table rule.
+
+### Syntax
+
+```sql
+DropDefaultSingleTableRule ::=
+ 'DROP' 'DEFAULT' 'SINGLE' 'TABLE' 'RULE' ifExists?
+
+ifExists ::=
+ 'IF' 'EXISTS'
+```
+
+
+### Example
+
+#### drop a default single table rule
+
+```sql
+DROP DEFAULT SINGLE TABLE RULE;
+```
+
+### Reserved word
+
+`DROP`, `SHARDING`, `SINGLE`, `TABLE`, `RULE`
+
+### Related links
+
+- [Reserved word](/en/reference/distsql/syntax/reserved-word/)