ALTER VIEW

Description

ALTER VIEW is used to alter an existing view.

If any of the views named in the syntax parameter list do not exist, the statement reports an error and cannot change those views that do not exist.

Syntax

  1. > ALTER VIEW view_name [(column_list)]
  2.   AS select_statement
  3.   [WITH [CASCADED | LOCAL] CHECK OPTION]

Examples

  1. drop table if exists t1;
  2. create table t1 (a int);
  3. insert into t1 values(1),(2),(3),(4);
  4. create view v5 as select * from t1;
  6. mysql> select * from v5;
  7. +------+
  8. | a    |
  9. +------+
  10. |    1 |
  11. |    2 |
  12. |    3 |
  13. |    4 |
  14. +------+
  15. 4 rows in set (0.01 sec)
  17. alter view v5 as select * from t1 where a=1;
  19. mysql> select * from v5;
  20. +------+
  21. | a    |
  22. +------+
  23. |    1 |
  24. +------+
  25. 1 row in set (0.01 sec)
  27. alter view v5 as select * from t1 where a > 2;
  29. mysql> select * from v5;
  30. +------+
  31. | a    |
  32. +------+
  33. |    3 |
  34. |    4 |
  35. +------+
  36. 2 rows in set (0.00 sec)