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

时间:2023-11-16 09:08:32

语法格式

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-v3-gaussdb/gaussdb-12-0534.html