MySQL 8.3 Release Notes
To obtain metadata about views:
-
Query the
VIEWS
table of theINFORMATION_SCHEMA
database. See Section 28.3.48, “The INFORMATION_SCHEMA VIEWS Table”. -
Use the
SHOW CREATE VIEW
statement. See Section 15.7.7.14, “SHOW CREATE VIEW Statement”.