文档首页/ 数据仓库服务 GaussDB(DWS)/ 更多文档/ 工具指南（吉隆坡地区）/ DSC SQL语法迁移工具/ Netezza语法迁移/ Index
更新时间：2022-08-16 GMT+08:00
查看PDF
分享

Index

Unique Index

Netezza语法

迁移后语法

 
CREATE TABLE  prod
(
     prod_no              number(6)      not null    unique,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null     
     CONSTRAINT UQ_prod unique,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null    PRIMARY KEY,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null,
     prod_name         national character varying(32)      not null,
     prod_desc          clob,
     constraint          uq_prod    UNIQUE (prod_no)
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE ON (prod_no)
ORGANIZE   ON (prod_no, prod_name)
;
ALTER TABLE prod
    ADD constraint          uq_prod    UNIQUE (prod_no);

CREATE TABLE  prod
(
     prod_no              number(6)      not null   /* unique */,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* ORGANIZE   ON (prod_no, prod_name) */
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null   
  /* CONSTRAINT UQ_prod unique */,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* ORGANIZE   ON (prod_no, prod_name) */
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null   /* PRIMARY KEY */,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* ORGANIZE   ON (prod_no, prod_name) */
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null,
     prod_name         national character varying(32)      not null,
     prod_desc          clob  /*,
    constraint          uq_prod    UNIQUE (prod_no)  */
) WITH(ORIENTATION=COLUMN)
DISTRIBUTE BY HASH (prod_no)
/* ORGANIZE   ON (prod_no, prod_name)*/
;
----------
CREATE TABLE  prod
(
     prod_no              number(6)      not null,
     prod_name         national character varying(32)      not null,
     prod_desc          clob
)
DISTRIBUTE BY HASH (prod_no)
/*ORGANIZE   ON (prod_no, prod_name)*/
;
/*
ALTER TABLE prod
    ADD constraint          uq_prod    UNIQUE (prod_no);
*/

仅适用于COLUMN store。对于ROW存储，不应注释“唯一索引”。

父主题： Netezza语法迁移