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

时间:2024-11-02 18:53:37

语法格式

1
2
3
4
5
6
7
8
CREATE [ UN LOG GED ] TABLE table_name
    [ (column_name [, ...] ) ]
    [ WITH ( {storage_parameter = value} [, ... ] ) ]
    [ 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-12-0380.html