This is an automated email from the ASF dual-hosted git repository. morrysnow pushed a commit to branch update_drop_table_ctas in repository https://gitbox.apache.org/repos/asf/doris-website.git
commit 7c8bb1f1661dccca94812a880b3a739b1c9ea3a8 Author: morrySnow <[email protected]> AuthorDate: Thu Sep 4 18:30:03 2025 +0800 [ddl] add drop temporary table and let as be optional in CTAS --- .../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 | 10 ++++++++-- .../sql-statements/table-and-view/view/CREATE-VIEW.md | 2 +- .../Create/CREATE-MATERIALIZED-VIEW.md | 2 +- 8 files changed, 23 insertions(+), 11 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..a213840d482 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 @@ -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]
