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.