23.5.5 View Metadata
To obtain metadata about views:
Query the
VIEWS
table of theINFORMATION_SCHEMA
database. See Section 24.31, “The INFORMATION_SCHEMA VIEWS Table”.Use the
SHOW CREATE VIEW
statement. See Section 13.7.5.13, “SHOW CREATE VIEW Statement”.