MySQL 9.2 Release Notes
To obtain metadata about views:
Query the
VIEWStable of theINFORMATION_SCHEMAdatabase. See Section 28.3.49, “The INFORMATION_SCHEMA VIEWS Table”.Use the
SHOW CREATE VIEWstatement. See Section 15.7.7.15, “SHOW CREATE VIEW Statement”.