云数据库 GaussDB-CREATE TABLE PARTITION:语法格式

时间：2025-02-12 15:06:01

云数据库 GaussDB

语法格式

  
       CREATE TABLE [ IF NOT EXISTS ] partition_table_name( [     { column_name data_type [ COLLATE collation ] [ column_constraint [ ... ] ]    | table_constraint    | LIKE source_table [ like_option [...] ] }    [, ... ]] )    [ WITH ( {storage_parameter = value} [, ... ] ) ]    [ COMPRESS | NOCOMPRESS ]    [ TABLESPACE tablespace_name ]    [ DISTRIBUTE BY { REPLICATION | HASH ( column_name [, ...] )     | RANGE ( column_name [, ...] ) { SLICE REFEREN CES  tablename | ( slice_less_than_item [, ...] )    | ( slice_start_end_item [, ...] ) }    | LIST ( column_name [, ...] ) { SLICE REFERENCES tablename | ( slice_values_item [, ...] ) }    } ]    [ TO { GROUP groupname | NODE ( nodename [, ... ] ) } ]    PARTITION BY {         {RANGE [COLUMNS] (partition_key) [ PARTITIONS integer ] ( partition_less_than_item [, ... ] )} |        {RANGE [COLUMNS] (partition_key) [ PARTITIONS integer ] ( partition_start_end_item [, ... ] )} |        {LIST [COLUMNS] (partition_key) [ PARTITIONS integer ] ( PARTITION partition_name VALUES [IN] (list_values) [TABLESPACE [=] tablespace_name][, ... ]）} |        { HASH (partition_key) [ PARTITIONS integer ] ( PARTITION partition_name [TABLESPACE [=] tablespace_name][, ... ]）}    } [ { ENABLE | DISABLE } ROW MOVEMENT ];

列约束column_constraint：

    
         [ CONSTRAINT constraint_name ]{ NOT NULL |  NULL |   CHECK ( expression ) |   DEFAULT default_expr |   UNIQUE [KEY] [ index_parameters ] |   PRIMARY KEY [ index_parameters] }[ DEFERRABLE | NOT DEFERRABLE ][ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

表约束table_constraint：

[ CONSTRAINT constraint_name ]{ CHECK ( expression ) |   UNIQUE ( column_name [, ... ] ) [ index_parameters ] |   PRIMARY KEY ( column_name [, ... ] ) [ index_parameters]}[ DEFERRABLE | NOT DEFERRABLE ][ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

like选项like_option：

    
         { INCLUDING | EXCLUDING } { DEFAULTS | CONSTRAINTS | INDEXES | STORAGE | COMMENTS | RELOPTIONS | DISTRIBUTION | ALL }

索引存储参数index_parameters：

    
         [ WITH ( {storage_parameter = value} [, ... ] ) ][ USING INDEX TABLESPACE tablespace_name ]

上一篇：云数据库 GaussDB-CREATE TABLE PARTITION:注意事项

下一篇：云数据库 GaussDB-CREATE TABLE PARTITION:参数说明

开年采购季抽奖赢万元免单

立即前往

续费同价 L实例 2核2G 4M

98元/年

企业专享 X实例 2核4G 5M

198元/年

热门域名 1元随心购

1元/年起

云数据库 GaussDB-CREATE TABLE PARTITION:语法格式

意见反馈

0/200

提交取消

提交成功！非常感谢您的反馈，我们会继续努力做到更好反馈提交失败！请稍后重试！

云数据库 GaussDB-CREATE TABLE PARTITION:语法格式

云数据库 GaussDB-CREATE TABLE PARTITION:语法格式

语法格式

7*24

备案

专业服务

退订

建议反馈

售前咨询热线