Metadata about views can be obtained as follows:
Query the VIEWS table of the
INFORMATION_SCHEMA database. See
Section 19.17, “The INFORMATION_SCHEMA VIEWS Table”.
Use the SHOW CREATE VIEW
statement. See Section 13.7.5.10, “SHOW CREATE VIEW Syntax”.