10.4 修改视图

10.4.1 使用CREATE OR REPLACE VIEW语句修改视图

语法：

CREATE [OR REPLACE] [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW 视图名 [(列名)]
AS sql语句 
[WITH [CASCADED | LOCAL] CHECK OPTION]

备注：与创建视图相同，视图存在则修改，不存在则创建

举例：

CREATE OR REPLACE VIEW v1 AS SELECT * FROM tab;

10.4.2 使用ALTER语句修改视图

语法：

ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW 视图名 [(列名)]
AS sql语句 
[WITH [CASCADED | LOCAL] CHECK OPTION]

举例：

ALTER VIEW v1 AS SELECT tab.name FROM tab