27.5.5 View Metadata

Skip to Main Content

MySQL 8.4 Reference Manual Including MySQL NDB Cluster 8.4

27.5.5 View Metadata

To obtain metadata about views:

• Query the VIEWS table of the INFORMATION_SCHEMA database. See Section 28.3.47, “The INFORMATION_SCHEMA VIEWS Table”.
• Use the SHOW CREATE VIEW statement. See Section 15.7.7.14, “SHOW CREATE VIEW Statement”.