Table of Contents
Views (including updatable views) are available in MySQL Server
This chapter discusses the following topics:
Creating or altering views with CREATE VIEW
or ALTER VIEW
Destroying views with DROP VIEW
Discussion of restrictions on use of views is given in
Section I.4, “Restrictions on Views”.
To use views if you have upgraded to MySQL 5.1 from an
older release that did not support views, you should upgrade your
grant tables so that they contain the view-related privileges. See
Section 5.5.2, “mysql_upgrade — Check Tables for MySQL Upgrade”.
Metadata about views can be obtained from the
INFORMATION_SCHEMA.VIEWS table and by using the
SHOW CREATE VIEW statement. See
Section 23.15, “The INFORMATION_SCHEMA VIEWS Table”, and
Section 220.127.116.11, “SHOW CREATE VIEW Syntax”.
SHOW CREATE VIEW