数据仓库服务 GaussDB(DWS)-ALTER TABLE RENAME

时间：2025-02-12 15:05:07

ALTER TABLE RENAME

GaussDB (DWS)不支持rename子句包含schema名，因此DSC工具只支持同schema下的rename。同schema下rename，转换结果去掉子句schema，跨schema的rename报错。

输入示例

     
          ALTER TABLE `shce1`.`t1` rename to `t2`;ALTER TABLE `shce1`.`t1` rename to t2;ALTER TABLE `charge_data`.`group_shengfen2022` RENAME `charge_data`.`group_shengfen2022_jiu`;ALTER TABLE `charge_data`.`group_shengfen2022` RENAME `charge_data`.`group_shengfen2022_jiu`, RENAME `charge_data`.`group_shengfen2023_jiu`, RENAME `charge_data`.`group_shengfen2024_jiu`;

输出示例

     
          ALTER TABLE "shce1"."t1" RENAME TO "t2";ALTER TABLE "shce1"."t1" RENAME TO "t2";ALTER TABLE "charge_data"."group_shengfen2022" RENAME TO "group_shengfen2022_jiu";ALTER TABLE "charge_data"."group_shengfen2022" RENAME TO "group_shengfen2022_jiu", RENAME TO "group_shengfen2023_jiu", RENAME TO "group_shengfen2024_jiu";