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