This is an automated email from the ASF dual-hosted git repository.
morrysnow pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new a61128abd7f [ddl] add drop temporary table and let as be optional in
CTAS (#2840)
a61128abd7f is described below
commit a61128abd7fbdbebd2c6f7f8c8cafc01fe6c0c0c
Author: morrySnow <[email protected]>
AuthorDate: Fri Sep 5 00:07:08 2025 +0800
[ddl] add drop temporary table and let as be optional in CTAS (#2840)
---
.../sync-materialized-view/CREATE-MATERIALIZED-VIEW.md | 2 +-
.../sql-statements/table-and-view/table/CREATE-TABLE.md | 2 +-
.../sql-statements/table-and-view/table/DROP-TABLE.md | 12 +++++++++---
.../sql-statements/table-and-view/view/CREATE-VIEW.md | 2 +-
.../sql-statements/table-and-view/table/CREATE-TABLE.md | 2 +-
.../sql-statements/table-and-view/table/DROP-TABLE.md | 12 +++++++++---
.../sql-statements/table-and-view/view/CREATE-VIEW.md | 2 +-
.../Create/CREATE-MATERIALIZED-VIEW.md | 2 +-
8 files changed, 24 insertions(+), 12 deletions(-)
diff --git
a/docs/sql-manual/sql-statements/table-and-view/sync-materialized-view/CREATE-MATERIALIZED-VIEW.md
b/docs/sql-manual/sql-statements/table-and-view/sync-materialized-view/CREATE-MATERIALIZED-VIEW.md
index 02a72c6adb4..d7004d0060b 100644
---
a/docs/sql-manual/sql-statements/table-and-view/sync-materialized-view/CREATE-MATERIALIZED-VIEW.md
+++
b/docs/sql-manual/sql-statements/table-and-view/sync-materialized-view/CREATE-MATERIALIZED-VIEW.md
@@ -12,7 +12,7 @@ Statement for creating a synchronized materialized view.
## Syntax
```sql
-CREATE MATERIALIZED VIEW <materialized_view_name> AS <query>
+CREATE MATERIALIZED VIEW <materialized_view_name> [AS] <query>
```
Where
diff --git
a/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
b/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
index 3014a45197c..8845964b90a 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
@@ -154,7 +154,7 @@ CREATE
"<table_properties>"
[ , ... ]
) ]
-AS <query>;
+[ AS ] <query>;
```
### CREATE TABLE ... LIKE
diff --git a/docs/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
b/docs/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
index 2cc88934431..1d8fb56edc9 100644
--- a/docs/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
+++ b/docs/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
@@ -11,7 +11,7 @@ This statement is used to delete a Table.
## Syntax
```sql
-DROP TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
+DROP [TEMPORARY] TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
```
## Required Parameters
@@ -26,7 +26,13 @@ DROP TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
## Optional Parameters
-**1.`<db_name>`**
+**1. `TEMPORARY` **
+> If specifies, the statement drops only TEMPORARY tables.
+
+**2. `IF EXISTS`**
+> IF specifies, no error occurs for nonexisting tables.
+
+**3.`<db_name>`**
> Specifies the identifier (name) for the database.
>
> Identifiers must begin with an alphabetic character (or any character in a
> given language if unicode name support is enabled) and cannot contain spaces
> or special characters unless the entire identifier string is enclosed in
> backticks (e.g., `My Database`).
@@ -35,7 +41,7 @@ DROP TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
>
> See Identifier Requirements and Reserved Keywords for more details.
-**2.`FORCE`**
+**4.`FORCE`**
> If specified, the system will not check whether there are any unfinished
> transactions in the table. The table will be deleted directly and cannot be
> recovered. This operation is generally not recommended.
## Access Control Requirements
diff --git a/docs/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
b/docs/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
index bc47c49b16c..c7d29f535bf 100644
--- a/docs/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
+++ b/docs/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
@@ -14,7 +14,7 @@ This statement is used to create a logical view using a
specified query statemen
```sql
CREATE VIEW [IF NOT EXISTS] [<db_name>.]<view_name>
[(<column_definition>)]
-AS <query_stmt>
+[AS] <query_stmt>
```
Where:
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
index 094fb1e207a..e4fd6633c40 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/CREATE-TABLE.md
@@ -156,7 +156,7 @@ CREATE
-- 其他表属性
[ , ... ])
]
- AS <query>
+ [ AS ] <query>
```
### CREATE TABLE … LIKE
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
index 4b1de78d5b6..b0ac50c7244 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/table/DROP-TABLE.md
@@ -11,7 +11,7 @@
## 语法
```sql
-DROP TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
+DROP [TEMPORARY] TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
```
## 必选参数
@@ -26,7 +26,13 @@ DROP TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
## 可选参数
-**1.`<db_name>`**
+**1. `TEMPORARY` **
+> 如果指定, 则只删除临时表
+
+**2. `IF EXISTS`**
+> 如果指定，则当表不存在时，不会报错。
+
+**3.`<db_name>`**
> 指定数据库的标识符（即名称）。
>
> 标识符必须以字母字符（如果开启 unicode
> 名字支持，则可以是任意语言文字的字符）开头，并且不能包含空格或特殊字符，除非整个标识符字符串用反引号括起来（例如`My Database`）。
@@ -35,7 +41,7 @@ DROP TABLE [IF EXISTS] [<db_name>.]<table_name> [FORCE];
>
> 有关更多详细信息，请参阅标识符要求和保留关键字。
-**2.`FORCE`**
+**4.`FORCE`**
> 如果指定，则系统不会检查该表是否存在未完成的事务，表将直接被删除并且不能被恢复，一般不建议执行此操作。
## 权限控制
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
index d38706bf7bb..385b79f18dd 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/view/CREATE-VIEW.md
@@ -14,7 +14,7 @@
```sql
CREATE VIEW [IF NOT EXISTS] [<db_name>.]<view_name>
[(<column_definition>)]
-AS <query_stmt>
+[AS] <query_stmt>
```
其中：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
index d3d19ac7931..3274c2d6b63 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-1.2/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-MATERIALIZED-VIEW.md
@@ -20,7 +20,7 @@ CREATE MATERIALIZED VIEW
语法：
```sql
-CREATE MATERIALIZED VIEW [MV name] as [query]
+CREATE MATERIALIZED VIEW [MV name] [AS] [query]
[PROPERTIES ("key" = "value")]
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
