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

时间:2024-11-02 18:48:28

语法格式

1
2
3
4
5
6
7
8
9
CREATE [ [ GLOBAL | LOCAL ] [ TEMPORARY | TEMP ] | UN LOG GED ] TABLE table_name
    [ (column_name [, ...] ) ]
    [ WITH ( {storage_parameter = value} [, ... ] ) ]
    [ COMPRESS | NOCOMPRESS ]
    [ TABLESPACE tablespace_name ]
    [ DISTRIBUTE BY { REPLICATION | { [HASH ] ( column_name ) } } ]
    [ TO { GROUP groupname | NODE ( nodename [, ... ] ) } ]
    AS query
    [ WITH [ NO ] DATA ];
support.huaweicloud.com/distributed-devg-v2-gaussdb/gaussdb_v5r2c10_0525.html