数据仓库服务 GaussDB(DWS)-表迁移:表名

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

数据仓库服务 GaussDB(DWS)

DWS不支持“数据库名.模式名.表名”的形式，需要对应转换为“模式名.表名”的形式。

SQL-Server语法	迁移后语法
CREATE TABLE `analytics-di-dev.abase.buyer_location` ( id_buyer INT, id_location INT );	CREATE TABLE "abase"."buyer_location" ("id_buyer" INT, "id_location" INT) WITH (ORIENTATION = ROW, COMPRESSION = NO) NOCOMPRESS DISTRIBUTE BY HASH ("id_buyer");

SQL-Server语法

迁移后语法

CREATE TABLE `analytics-di-dev.abase.buyer_location`

(

id_buyer INT,

id_location INT

);

CREATE TABLE "abase"."buyer_location"

("id_buyer" INT, "id_location" INT) WITH (ORIENTATION = ROW, COMPRESSION = NO) NOCOMPRESS DISTRIBUTE BY HASH ("id_buyer");