云数据库 GAUSSDB-ALTER MATERIALIZED VIEW:语法格式

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

语法格式

  • 修改物化视图的所属用户。
    ALTER MATERIALIZED VIEW [ IF EXISTS ] mv_name
        OWNER TO new_owner;
  • 修改物化视图的列。
    ALTER MATERIALIZED VIEW [ IF EXISTS ] mv_name
        RENAME [ COLUMN ] column_name TO new_column_name;
  • 重命名物化视图。
    ALTER MATERIALIZED VIEW [ IF EXISTS ] mv_name
        RENAME TO new_name;
support.huaweicloud.com/distributed-devg-v2-gaussdb/gaussdb_v5r2c10_0460.html