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

时间：2023-11-01 16:22:51

云数据库 GaussDB

语法格式

创建表。

    
         CREATE [ [ GLOBAL | LOCAL ] [ TEMPORARY | TEMP ] | UNLOGGED ] TABLE [ IF NOT EXISTS ] table_name     ({ column_name data_type [ compress_mode ] [ COLLATE collation ] [ column_constraint [ ... ] ]        | table_constraint        | LIKE source_table [ like_option [...] ] }        [, ... ])    [ WITH ( {storage_parameter = value} [, ... ] ) ]    [ ON COMMIT { PRESERVE ROWS | DELETE ROWS } ]    [ COMPRESS | NOCOMPRESS ]    [ TABLESPACE tablespace_name ]    [ DISTRIBUTE BY { REPLICATION | HASH ( column_name [, ...] )     | RANGE ( column_name [, ...] ) { SLICE REFERENCES tablename | ( slice_less_than_item [, ...] )    | ( slice_start_end_item [, ...] ) }    | LIST ( column_name [, ...] ) { SLICE REFERENCES tablename | ( slice_values_item [, ...] ) }    } ]    [ TO { GROUP groupname | NODE ( nodename [, ... ] ) } ];

其中列约束column_constraint为：

      
           [ CONSTRAINT constraint_name ]{ NOT NULL |  NULL |  CHECK ( expression ) |   DEFAULT default_expr |  UNIQUE [ index_parameters ] |  PRIMARY KEY [ index_parameters ] |  ENCRYPTED WITH ( COLUMN_ENCRYPTION_KEY = column_encryption_key, ENCRYPTION_TYPE = encryption_type_value ) }  REFERENCES reftable [ ( refcolumn ) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ]    [ ON DELETE action ] [ ON UPDATE action ] }[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

其中列的压缩可选项compress_mode为：

      
           { DELTA | PREFIX | DICTIONARY | NUMSTR | NOCOMPRESS }

其中表约束table_constraint为：

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

其中like选项like_option为：

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

其中RANGE分布规则
 slice_less_than_item为：
SLICE slice_name VALUES LESS THAN ({ literal | MAXVALUE } [, ...]) [ DATANODE dn_name ]
slice_start_end_item为：
SLICE slice_name_prefix {
{ START ( literal ) END ( literal ) EVERY ( literal ) } |
{ START ( literal ) END ( { literal | MAXVALUE } ) } |
{ START ( literal ) } |
{ END ( { literal | MAXVALUE } ) }
}
其中LIST分布规则slice_values_item为：
SLICE slice_name VALUES (list_values_item) [DATANODE dn_name]
list_values_item为：
{ DEFAULT | { partition_values_list [, ...] } }
partition_values_list为:
{ (literal [, ...]) }

其中索引参数index_parameters为：

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

上一篇：云数据库 GaussDB-CREATE TABLE:优化建议

下一篇：云数据库 GaussDB-CREATE TABLE:优化建议

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

意见反馈

0/200

提交取消

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

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

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

语法格式

7*24

备案

专业服务

退订

建议反馈

售前咨询热线