更新时间:2024-06-29 GMT+08:00
ALTER MATERIALIZED VIEW
功能描述
修改物化视图属性。
![](https://support.huaweicloud.com/intl/zh-cn/sqlreference-830-dws/public_sys-resources/notice_3.0-zh-cn.png)
物化视图功能仅8.3.0及以上集群支持,需联系技术支持开启。
注意事项
无
语法格式
ALTER MATERIALIZED VIEW [ IF EXISTS ] { materialized_view_name } [ ENABLE | DISABLE ] QUERY REWRITE; ALTER MATERIALIZED VIEW [ IF EXISTS ] { materialized_view_name } REFRESH [ COMPLETE ] [ ON DEMAND ] [ [ START WITH (timestamptz) ] | [ EVERY (interval) ] ]; ALTER MATERIALIZED VIEW { materialized_view_name } OWNER TO new_owner;
参数说明
示例
启用物化视图的查询重写。
ALTER MATERIALIZED VIEW mv1 ENABLE QUERY REWRITE; NOTICE: REFRESH MATERIALIZED VIEW should be executed to enable query rewrite. ALTER MATERIALIZED VIEW
父主题: DDL语法