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

时间:2024-11-13 14:46:45

语法格式

CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name ( [
    column_name type_name [ OPTIONS ( { option 'value' } [, ... ] ) ] [ COLLATE collation ] [ column_constraint [ ... ] ]
    [, ... ]
] )
  SERVER server_name
[ OPTIONS ( { option 'value' } [, ... ] ) ];
其中列约束column_constraint为:
[ CONSTRAINT constraint_name ]
{ NOT NULL |
  NULL |
  DEFAULT default_expr }
support.huaweicloud.com/centralized-devg-v8-gaussdb/gaussdb-42-0547.html