GBase 8c 视图管理

--- 创建数据表
drop table if exists tab_1 CASCADE;

CREATE TABLE tab_1( id int, name varchar(10) );

--- 插入数据
INSERT INTO tab_1 VALUES (1,'1');

--- 创建视图
CREATE VIEW v1 AS SELECT * FROM tab_1;

--- 创建物化视图
CREATE MATERIALIZED VIEW mv1 AS SELECT * FROM tab_1;

--- 查询视图数据
SELECT * FROM v1;

--- 重命名视图
ALTER VIEW v1 RENAME TO v2;

--- 查询物化视图数据 
SELECT * FROM mv1;

--- 验证物化视图是否随基本变化而变化
INSERT INTO tab_1 VALUES (2,'2');

SELECT * FROM mv1;

--- 刷新物化视图
REFRESH MATERIALIZED VIEW mv1;

SELECT * FROM mv1;

--- 删除视图
DROP VIEW v2; 
--- 删除物化视图
DROP MATERIALIZED VIEW mv1;