MySQL 5.7 Reference Manual Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6
To obtain metadata about views:
Query the VIEWS table of the
INFORMATION_SCHEMA database. See
Section 24.3.31, “The INFORMATION_SCHEMA VIEWS Table”.
Use the SHOW CREATE VIEW
statement. See Section 13.7.5.13, “SHOW CREATE VIEW Statement”.