MySQL 9.0 Reference Manual Including MySQL NDB Cluster 9.0
To obtain metadata about views:
Query the VIEWS table of the
INFORMATION_SCHEMA database. See
Section 28.3.47, “The INFORMATION_SCHEMA VIEWS Table”.
Use the SHOW CREATE VIEW
statement. See Section 15.7.7.14, “SHOW CREATE VIEW Statement”.