This is an automated email from the ASF dual-hosted git repository. czweng pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/flink-table-store.git
The following commit(s) were added to refs/heads/master by this push: new 659a5ce4 [FLINK-30521] Improve Altering Tables of Doc 659a5ce4 is described below commit 659a5ce4b1b7a45c506391476b3b67396346403f 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. --- 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.