MySQL 5.6 Reference Manual Including MySQL NDB Cluster 7.3-7.4 Reference Guide
To obtain metadata about views:
Query the VIEWS
table of the
INFORMATION_SCHEMA
database. See
Section 21.29, “The INFORMATION_SCHEMA VIEWS Table”.
Use the SHOW CREATE VIEW
statement. See Section 13.7.5.14, “SHOW CREATE VIEW Statement”.