To obtain metadata about views:
Query the VIEWS table of the INFORMATION_SCHEMA database. See Section 26.3.48, “The INFORMATION_SCHEMA VIEWS Table”.
VIEWS
INFORMATION_SCHEMA
Use the SHOW CREATE VIEW statement. See Section 13.7.7.13, “SHOW CREATE VIEW Statement”.
SHOW CREATE VIEW