MySQL 5.5 Reference Manual :: 18 Stored Programs and Views :: 18.5 Using Views :: 18.5.4 View Metadata
Section Navigation [Toggle]
Metadata about views can be obtained as follows:
Query the
VIEWStable of theINFORMATION_SCHEMAdatabase. See Section 19.15, “TheINFORMATION_SCHEMA VIEWSTable”.Use the
SHOW CREATE VIEWstatement. See Section 12.4.5.14, “SHOW CREATE VIEWSyntax”.
User Comments
Add your own comment.