MySQL 8.4 Release Notes
27.5.5 视图元数据
To obtain metadata about views:
-
Query the
VIEWStable of theINFORMATION_SCHEMAdatabase. See Section 28.3.47, “The INFORMATION_SCHEMA VIEWS Table”. -
Use the
SHOW CREATE VIEWstatement. See Section 15.7.7.14, “SHOW CREATE VIEW Statement”.