This is an automated email from the ASF dual-hosted git repository.
critas pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/iotdb-docs.git
The following commit(s) were added to refs/heads/main by this push:
new ebe001ae add show create table to table statement from 205 (#974)
ebe001ae is described below
commit ebe001ae7dcafebf9040f4c0af5e83702a38a327
Author: leto-b <[email protected]>
AuthorDate: Wed Feb 4 11:59:40 2026 +0800
add show create table to table statement from 205 (#974)
---
.../Table/Basic-Concept/Table-Management_apache.md | 34 ++++++++++++++++++++--
.../Basic-Concept/Table-Management_timecho.md | 33 +++++++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_apache.md | 27 +++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_timecho.md | 26 +++++++++++++++--
.../Table/User-Manual/Tree-to-Table_apache.md | 20 +++++--------
.../Table/User-Manual/Tree-to-Table_timecho.md | 20 +++++--------
.../Basic-Concept/Table-Management_apache.md | 34 ++++++++++++++++++++--
.../Basic-Concept/Table-Management_timecho.md | 33 +++++++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_apache.md | 27 +++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_timecho.md | 26 +++++++++++++++--
.../User-Manual/Tree-to-Table_apache.md | 20 +++++--------
.../User-Manual/Tree-to-Table_timecho.md | 20 +++++--------
.../Table/Basic-Concept/Table-Management_apache.md | 33 +++++++++++++++++++--
.../Basic-Concept/Table-Management_timecho.md | 34 ++++++++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_apache.md | 25 ++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_timecho.md | 25 ++++++++++++++--
.../Table/User-Manual/Tree-to-Table_apache.md | 20 +++++--------
.../Table/User-Manual/Tree-to-Table_timecho.md | 19 +++++-------
.../Basic-Concept/Table-Management_apache.md | 33 +++++++++++++++++++--
.../Basic-Concept/Table-Management_timecho.md | 34 ++++++++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_apache.md | 25 ++++++++++++++--
.../SQL-Manual/SQL-Metadata-Operations_timecho.md | 25 ++++++++++++++--
.../User-Manual/Tree-to-Table_apache.md | 20 +++++--------
.../User-Manual/Tree-to-Table_timecho.md | 19 +++++-------
24 files changed, 504 insertions(+), 128 deletions(-)
diff --git
a/src/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
b/src/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
index 820279d3..6b7bb0cb 100644
--- a/src/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
+++ b/src/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
@@ -271,7 +271,37 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 Update Tables
+
+### 1.4 View Table Creation Statement
+
+Retrieves the complete definition statement of a table or view under the table
model. This feature automatically fills in all default values that were omitted
during creation, so the displayed statement may differ from the original CREATE
statement.
+
+> This feature is supported starting from v2.0.5.
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Note:：**
+
+1. This statement does not support queries on system tables.
+
+**Example:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 Update Tables
Used to update a table, including adding or deleting columns and configuring
table properties.
@@ -302,7 +332,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 Delete Tables
+### 1.6 Delete Tables
Used to delete a table.
diff --git
a/src/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
b/src/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
index 19d3a5e0..7e2e628a 100644
--- a/src/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
+++ b/src/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
@@ -271,7 +271,36 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 Update Tables
+### 1.4 View Table Creation Statement
+
+Retrieves the complete definition statement of a table or view under the table
model. This feature automatically fills in all default values that were omitted
during creation, so the displayed statement may differ from the original CREATE
statement.
+
+> This feature is supported starting from v2.0.5.
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Note:：**
+
+1. This statement does not support queries on system tables.
+
+**Example:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 Update Tables
Used to update a table, including adding or deleting columns and configuring
table properties.
@@ -302,7 +331,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 Delete Tables
+### 1.6 Delete Tables
Used to delete a table.
diff --git
a/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
b/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
index a96828c8..00cb489d 100644
--- a/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
+++ b/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
@@ -277,7 +277,30 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 Modify Table
+
+### 2.4 View Table Creation Statement
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Examples:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+
+### 2.5 Modify Table
**Syntax:**
@@ -300,7 +323,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 Drop Table
+### 2.6 Drop Table
**Syntax:**
diff --git
a/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
b/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
index 7c94bf29..5c68a9b4 100644
--- a/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
+++ b/src/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
@@ -277,7 +277,29 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 Modify Table
+
+### 2.4 View Table Creation Statement
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Examples:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 2.5 Modify Table
**Syntax:**
@@ -300,7 +322,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 Drop Table
+### 2.6 Drop Table
**Syntax:**
diff --git a/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
b/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
index b9b1d06b..f1de07b9 100644
--- a/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
+++ b/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
@@ -261,29 +261,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. Syntax Definition
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. Syntax Explanation
-* The `SHOW CREATE TABLE`statement can be used to display the complete
creation information for ordinary tables or views.
-* The `SHOW CREATE VIEW`statement can only be used to display the complete
creation information for views.
-* Neither statement can be used to display system tables.
+* This statement retrieves the complete definition of a table or view.
+* It automatically fills in all default values omitted during creation, so the
statement shown in the result may differ from the original CREATE statement.
+* This statement does not support system tables.
3. Usage Examples
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -292,6 +285,9 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> Additionally, you can also use the `SHOW CREATE TABLE` statement to view the
creation information of table views. For more details, see [show create
table](../Basic-Concept/Table-Management_apache.md#_1-4-view-table-creation-statement)
+
+
### 2.5 Query Differences Between Non-aligned and Aligned Devices
Queries on tree-to-table views may yield different results compared to
equivalent tree model `ALIGN BY DEVICE`queries when dealing with null values in
aligned and non-aligned devices.
diff --git a/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
b/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
index d855bd5e..7e047e97 100644
--- a/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
+++ b/src/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
@@ -261,29 +261,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. Syntax Definition
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. Syntax Explanation
-* The `SHOW CREATE TABLE`statement can be used to display the complete
creation information for ordinary tables or views.
-* The `SHOW CREATE VIEW`statement can only be used to display the complete
creation information for views.
-* Neither statement can be used to display system tables.
+* This statement retrieves the complete definition of a table or view.
+* It automatically fills in all default values omitted during creation, so the
statement shown in the result may differ from the original CREATE statement.
+* This statement does not support system tables.
3. Usage Examples
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -292,6 +285,9 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> Additionally, you can also use the `SHOW CREATE TABLE` statement to view the
creation information of table views. For more details, see [show create
table](../Basic-Concept/Table-Management_timecho.md#_1-4-view-table-creation-statement)
+
+
### 2.5 Query Differences Between Non-aligned and Aligned Devices
Queries on tree-to-table views may yield different results compared to
equivalent tree model `ALIGN BY DEVICE`queries when dealing with null values in
aligned and non-aligned devices.
diff --git
a/src/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
b/src/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
index 820279d3..6b7bb0cb 100644
--- a/src/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
+++ b/src/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
@@ -271,7 +271,37 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 Update Tables
+
+### 1.4 View Table Creation Statement
+
+Retrieves the complete definition statement of a table or view under the table
model. This feature automatically fills in all default values that were omitted
during creation, so the displayed statement may differ from the original CREATE
statement.
+
+> This feature is supported starting from v2.0.5.
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Note:：**
+
+1. This statement does not support queries on system tables.
+
+**Example:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 Update Tables
Used to update a table, including adding or deleting columns and configuring
table properties.
@@ -302,7 +332,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 Delete Tables
+### 1.6 Delete Tables
Used to delete a table.
diff --git
a/src/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
b/src/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
index 19d3a5e0..7e2e628a 100644
--- a/src/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
+++ b/src/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
@@ -271,7 +271,36 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 Update Tables
+### 1.4 View Table Creation Statement
+
+Retrieves the complete definition statement of a table or view under the table
model. This feature automatically fills in all default values that were omitted
during creation, so the displayed statement may differ from the original CREATE
statement.
+
+> This feature is supported starting from v2.0.5.
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Note:：**
+
+1. This statement does not support queries on system tables.
+
+**Example:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 Update Tables
Used to update a table, including adding or deleting columns and configuring
table properties.
@@ -302,7 +331,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 Delete Tables
+### 1.6 Delete Tables
Used to delete a table.
diff --git
a/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
b/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
index a96828c8..00cb489d 100644
--- a/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
+++ b/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
@@ -277,7 +277,30 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 Modify Table
+
+### 2.4 View Table Creation Statement
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Examples:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+
+### 2.5 Modify Table
**Syntax:**
@@ -300,7 +323,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 Drop Table
+### 2.6 Drop Table
**Syntax:**
diff --git
a/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
b/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
index 7c94bf29..5c68a9b4 100644
--- a/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
+++ b/src/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
@@ -277,7 +277,29 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 Modify Table
+
+### 2.4 View Table Creation Statement
+
+**Syntax:**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**Examples:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 2.5 Modify Table
**Syntax:**
@@ -300,7 +322,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 Drop Table
+### 2.6 Drop Table
**Syntax:**
diff --git a/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
b/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
index b9b1d06b..f1de07b9 100644
--- a/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
+++ b/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
@@ -261,29 +261,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. Syntax Definition
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. Syntax Explanation
-* The `SHOW CREATE TABLE`statement can be used to display the complete
creation information for ordinary tables or views.
-* The `SHOW CREATE VIEW`statement can only be used to display the complete
creation information for views.
-* Neither statement can be used to display system tables.
+* This statement retrieves the complete definition of a table or view.
+* It automatically fills in all default values omitted during creation, so the
statement shown in the result may differ from the original CREATE statement.
+* This statement does not support system tables.
3. Usage Examples
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -292,6 +285,9 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> Additionally, you can also use the `SHOW CREATE TABLE` statement to view the
creation information of table views. For more details, see [show create
table](../Basic-Concept/Table-Management_apache.md#_1-4-view-table-creation-statement)
+
+
### 2.5 Query Differences Between Non-aligned and Aligned Devices
Queries on tree-to-table views may yield different results compared to
equivalent tree model `ALIGN BY DEVICE`queries when dealing with null values in
aligned and non-aligned devices.
diff --git a/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
b/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
index d855bd5e..7e047e97 100644
--- a/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
+++ b/src/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
@@ -261,29 +261,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. Syntax Definition
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. Syntax Explanation
-* The `SHOW CREATE TABLE`statement can be used to display the complete
creation information for ordinary tables or views.
-* The `SHOW CREATE VIEW`statement can only be used to display the complete
creation information for views.
-* Neither statement can be used to display system tables.
+* This statement retrieves the complete definition of a table or view.
+* It automatically fills in all default values omitted during creation, so the
statement shown in the result may differ from the original CREATE statement.
+* This statement does not support system tables.
3. Usage Examples
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -292,6 +285,9 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> Additionally, you can also use the `SHOW CREATE TABLE` statement to view the
creation information of table views. For more details, see [show create
table](../Basic-Concept/Table-Management_timecho.md#_1-4-view-table-creation-statement)
+
+
### 2.5 Query Differences Between Non-aligned and Aligned Devices
Queries on tree-to-table views may yield different results compared to
equivalent tree model `ALIGN BY DEVICE`queries when dealing with null values in
aligned and non-aligned devices.
diff --git
a/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
b/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
index 727095ac..cc403027 100644
--- a/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
+++ b/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_apache.md
@@ -277,7 +277,36 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 修改表
+### 1.4 查看表的创建信息
+
+用于获取表模型下表或视图的完整定义语句。该功能会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+
+> V2.0.5 起支持该功能
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**说明：**
+
+1. 该语句不支持对系统表的查询
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 修改表
用于修改表，包括添加列、删除列以及设置表的属性。
@@ -308,7 +337,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 删除表
+### 1.6 删除表
用于删除表。
diff --git
a/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
b/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
index 1c48c587..ed4b890a 100644
--- a/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
+++ b/src/zh/UserGuide/Master/Table/Basic-Concept/Table-Management_timecho.md
@@ -277,7 +277,37 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 修改表
+
+### 1.4 查看表的创建信息
+
+用于获取表模型下表或视图的完整定义语句。该功能会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+
+> V2.0.5 起支持该功能
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**说明：**
+
+1. 该语句不支持对系统表的查询
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 修改表
用于修改表，包括添加列、删除列以及设置表的属性。
@@ -308,7 +338,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 删除表
+### 1.6 删除表
用于删除表。
diff --git
a/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
b/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
index b32a0d72..406f3af9 100644
--- a/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
+++ b/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_apache.md
@@ -275,7 +275,28 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 修改表
+### 2.4 查看表的创建信息
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 2.5 修改表
**语法：**
@@ -298,7 +319,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 删除表
+### 2.6 删除表
**语法：**
diff --git
a/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
b/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
index 31e1aaf7..27e7c1b7 100644
---
a/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
+++
b/src/zh/UserGuide/Master/Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
@@ -275,7 +275,28 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 修改表
+### 2.4 查看表的创建信息
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 2.5 修改表
**语法：**
@@ -298,7 +319,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 删除表
+### 2.6 删除表
**语法：**
diff --git a/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
b/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
index 06b2e5b6..efae2dda 100644
--- a/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
+++ b/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_apache.md
@@ -258,29 +258,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. 语法定义
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. 语法说明
-* SHOW CREATE TABLE 语句可用于展示普通表或者视图的完整创建信息；
-* SHOW CREATE VIEW 语句仅可用于展示视图的完整创建信息；
-* 两种语句均不支持用于展示系统表；
+* 该语句用于获取表视图的完整定义语句。
+* 该语句会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+* 该语句不支持用于展示系统表；
3. 使用示例
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -289,6 +282,9 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> 除此之外，还支持通过 `show create table` 语句查看表视图创建信息，相关详细介绍可查看[show create
table](../Basic-Concept/Table-Management_apache.md#_1-4-查看表的创建信息)
+
+
### 2.5 非对齐与对齐设备的查询差异
树转表视图在查询对齐设备和非对齐设备中有 null 值的情况下结果**可能与等价的树模型 align by device 查询不同**。
diff --git a/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
b/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
index 75378e3c..d3a0a622 100644
--- a/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
+++ b/src/zh/UserGuide/Master/Table/User-Manual/Tree-to-Table_timecho.md
@@ -258,29 +258,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. 语法定义
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. 语法说明
-* SHOW CREATE TABLE 语句可用于展示普通表或者视图的完整创建信息；
-* SHOW CREATE VIEW 语句仅可用于展示视图的完整创建信息；
-* 两种语句均不支持用于展示系统表；
+* 该语句用于获取表视图的完整定义语句。
+* 该语句会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+* 该语句不支持用于展示系统表；
3. 使用示例
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -289,6 +282,8 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> 除此之外，还支持通过 `show create table` 语句查看表视图创建信息，相关详细介绍可查看[show create
table](../Basic-Concept/Table-Management_timecho.md#_1-4-查看表的创建信息)
+
### 2.5 非对齐与对齐设备的查询差异
树转表视图在查询对齐设备和非对齐设备中有 null 值的情况下结果**可能与等价的树模型 align by device 查询不同**。
diff --git
a/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
b/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
index 727095ac..cc403027 100644
--- a/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
+++ b/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.md
@@ -277,7 +277,36 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 修改表
+### 1.4 查看表的创建信息
+
+用于获取表模型下表或视图的完整定义语句。该功能会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+
+> V2.0.5 起支持该功能
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**说明：**
+
+1. 该语句不支持对系统表的查询
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 修改表
用于修改表，包括添加列、删除列以及设置表的属性。
@@ -308,7 +337,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 删除表
+### 1.6 删除表
用于删除表。
diff --git
a/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
b/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
index 1c48c587..ed4b890a 100644
--- a/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
+++ b/src/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_timecho.md
@@ -277,7 +277,37 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 1.4 修改表
+
+### 1.4 查看表的创建信息
+
+用于获取表模型下表或视图的完整定义语句。该功能会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+
+> V2.0.5 起支持该功能
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**说明：**
+
+1. 该语句不支持对系统表的查询
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 1.5 修改表
用于修改表，包括添加列、删除列以及设置表的属性。
@@ -308,7 +338,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 1.5 删除表
+### 1.6 删除表
用于删除表。
diff --git
a/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
b/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
index b32a0d72..406f3af9 100644
--- a/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
+++ b/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md
@@ -275,7 +275,28 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 修改表
+### 2.4 查看表的创建信息
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 2.5 修改表
**语法：**
@@ -298,7 +319,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 删除表
+### 2.6 删除表
**语法：**
diff --git
a/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
b/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
index 31e1aaf7..27e7c1b7 100644
---
a/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
+++
b/src/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_timecho.md
@@ -275,7 +275,28 @@ IoTDB> desc table1 details
+------------+---------+---------+------+------------+
```
-### 2.4 修改表
+### 2.4 查看表的创建信息
+
+**语法：**
+
+```SQL
+SHOW CREATE TABLE <TABLE_NAME>
+```
+
+**示例:**
+
+```SQL
+IoTDB:database1> show create table table1
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+| Table|
Create Table|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+|table1|CREATE TABLE "table1" ("region" STRING TAG,"plant_id" STRING
TAG,"device_id" STRING TAG,"model_id" STRING ATTRIBUTE,"maintenance" STRING
ATTRIBUTE,"temperature" FLOAT FIELD,"humidity" FLOAT FIELD,"status" BOOLEAN
FIELD,"arrival_time" TIMESTAMP FIELD) WITH (ttl=31536000000)|
++------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+Total line number = 1
+```
+
+
+### 2.5 修改表
**语法：**
@@ -298,7 +319,7 @@ COMMENT ON TABLE table1 IS 'table1'
COMMENT ON COLUMN table1.a IS null
```
-### 2.5 删除表
+### 2.6 删除表
**语法：**
diff --git a/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
b/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
index 06b2e5b6..efae2dda 100644
--- a/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
+++ b/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_apache.md
@@ -258,29 +258,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. 语法定义
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. 语法说明
-* SHOW CREATE TABLE 语句可用于展示普通表或者视图的完整创建信息；
-* SHOW CREATE VIEW 语句仅可用于展示视图的完整创建信息；
-* 两种语句均不支持用于展示系统表；
+* 该语句用于获取表视图的完整定义语句。
+* 该语句会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+* 该语句不支持用于展示系统表；
3. 使用示例
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -289,6 +282,9 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> 除此之外，还支持通过 `show create table` 语句查看表视图创建信息，相关详细介绍可查看[show create
table](../Basic-Concept/Table-Management_apache.md#_1-4-查看表的创建信息)
+
+
### 2.5 非对齐与对齐设备的查询差异
树转表视图在查询对齐设备和非对齐设备中有 null 值的情况下结果**可能与等价的树模型 align by device 查询不同**。
diff --git a/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
b/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
index 75378e3c..d3a0a622 100644
--- a/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
+++ b/src/zh/UserGuide/latest-Table/User-Manual/Tree-to-Table_timecho.md
@@ -258,29 +258,22 @@ IoTDB> show tables details from information_schema
+--------------+-------+------+-------+-----------+
```
-#### 2.4.2 **`Show Create Table/View`**
+#### 2.4.2 **`Show Create View`**
1. 语法定义
```SQL
-SHOW CREATE TABLE|VIEW viewname;
+SHOW CREATE VIEW viewname;
```
2. 语法说明
-* SHOW CREATE TABLE 语句可用于展示普通表或者视图的完整创建信息；
-* SHOW CREATE VIEW 语句仅可用于展示视图的完整创建信息；
-* 两种语句均不支持用于展示系统表；
+* 该语句用于获取表视图的完整定义语句。
+* 该语句会自动补全创建时省略的所有默认值，因此结果集中所展示的语句可能与原始创建语句不同。
+* 该语句不支持用于展示系统表；
3. 使用示例
```SQL
-IoTDB> show create table tableview
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-| View|
Create View|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-|tableview|CREATE VIEW "tableview" ("device" STRING TAG,"model" STRING
TAG,"status" BOOLEAN FIELD,"hardware" STRING FIELD) COMMENT '树转表' WITH
(ttl=INF) AS root.ln.**|
-+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
-
IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View|
Create View|
@@ -289,6 +282,8 @@ IoTDB> show create view tableview
+---------+-------------------------------------------------------------------------------------------------------------------------------------------------------------+
```
+> 除此之外，还支持通过 `show create table` 语句查看表视图创建信息，相关详细介绍可查看[show create
table](../Basic-Concept/Table-Management_timecho.md#_1-4-查看表的创建信息)
+
### 2.5 非对齐与对齐设备的查询差异
树转表视图在查询对齐设备和非对齐设备中有 null 值的情况下结果**可能与等价的树模型 align by device 查询不同**。
