ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
VIEW view_name [(column_list)]
AS select_statement
[WITH [CASCADED | LOCAL] CHECK OPTION];
與 CREATE VIEW 幾乎相同,僅關鍵字改為 ALTER。
-- 1. 建立初始視圖:查詢 id=5
CREATE OR REPLACE VIEW view_111cn AS
SELECT * FROM net111 WHERE id = 5;
-- 2. 修改視圖:改為 id=6 或 7 且 url 固定
ALTER VIEW view_111cn AS
SELECT * FROM net111 WHERE id IN (6,7) AND url = 'https://www.111cn.net';
若不想用 ALTER,可用 DROP VIEW ...; CREATE VIEW ...; 達成相同效果,但需重新授權。
ALTER VIEW 需 CREATE VIEW + DROP 權限。