Metadata about views can be obtained as follows:
Query the
VIEWStable of theINFORMATION_SCHEMAdatabase. See Section 20.15, “TheINFORMATION_SCHEMA VIEWSTable”.Use the
SHOW CREATE VIEWstatement. See Section 12.4.5.14, “SHOW CREATE VIEWSyntax”.