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

时间：2024-11-13 14:46:43

云数据库 GAUSSDB

语法格式

CREATE [ [ GLOBAL | LOCAL ] [ TEMPORARY | TEMP ] | UN LOG GED ] TABLE [ IF NOT EXISTS ] table_name
    [ (column_name [, ...] ) ]
    [ { ENGINE [ = ] { InnoDB | 'InnoDB' | "InnoDB" } } [ [ , ] ... ] ]
    [ WITH ( {storage_parameter = value} [, ... ] ) ]
    [ ON COMMIT { PRESERVE ROWS | DELETE ROWS } ]
    [ ILM ADD POLICY ROW STORE COMPRESS ADVANCED ROW AFTER n { day | month | year } OF NO MODIFICATION [ ON ( EXPR )]]
    [ TABLESPACE tablespace_name ]
    AS query
    [ WITH [ NO ] DATA ];

上一篇：云数据库 GAUSSDB-CREATE TABLE AS:功能描述

下一篇：云数据库 GAUSSDB-CREATE TABLE AS:功能描述