This is an automated email from the ASF dual-hosted git repository.
czweng pushed a commit to branch release-0.3
in repository https://gitbox.apache.org/repos/asf/flink-table-store.git
The following commit(s) were added to refs/heads/release-0.3 by this push:
new cfd13236 [FLINK-30521] Improve Altering Tables of Doc
cfd13236 is described below
commit cfd132362b14ba66b41db3264ca70d34e496cc78
Author: yuzelin <33053040+yuze...@users.noreply.github.com>
AuthorDate: Thu Dec 29 10:48:55 2022 +0800
[FLINK-30521] Improve Altering Tables of Doc
This closes #446.
(cherry picked from commit 659a5ce4b1b7a45c506391476b3b67396346403f)
---
docs/content/docs/how-to/altering-tables.md | 44 +++++++++++++++++++++++++++++
1 file changed, 44 insertions(+)
diff --git a/docs/content/docs/how-to/altering-tables.md
b/docs/content/docs/how-to/altering-tables.md
index 03080149..48048872 100644
--- a/docs/content/docs/how-to/altering-tables.md
+++ b/docs/content/docs/how-to/altering-tables.md
@@ -97,6 +97,50 @@ ALTER TABLE my_table ADD COLUMNS (
{{< /tabs >}}
+## Renaming Column Name
+The following SQL renames column `c0` in table `my_table` to `c1`.
+
+{{< tabs "rename-column-name-example" >}}
+
+{{< tab "Spark3" >}}
+
+```sql
+ALTER TABLE my_table RENAME COLUMN c0 TO c1;
+```
+
+{{< /tab >}}
+
+{{< /tabs >}}
+
+## Dropping Columns
+The syntax is:
+
+{{< tabs "drop-columns-syntax" >}}
+
+{{< tab "Spark3" >}}
+
+```sql
+ALTER TABLE table_identifier DROP { COLUMN | COLUMNS } [(] col_name [, ... ]
[)]
+```
+
+{{< /tab >}}
+
+{{< /tabs >}}
+
+The following SQL drops tow columns `c1` and `c2` from table `my_table`.
+
+{{< tabs "drop-columns-example" >}}
+
+{{< tab "Spark3" >}}
+
+```sql
+ALTER TABLE my_table DROP COLUMNS (c1, c2);
+```
+
+{{< /tab >}}
+
+{{< /tabs >}}
+
## Changing Column Nullability
The following SQL sets column `coupon_info` to be nullable.
