MySQL 5.0 Reference Manual :: 18 Stored Programs and Views :: 18.4 Using Views :: 18.4.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.10, “SHOW CREATE VIEWSyntax”.
User Comments
Add your own comment.