文档首页
MySQL 8.4 参考手册
8.4 中文镜像

MySQL 8.4 参考手册 · 中文镜像

正文为中文,英文原文默认隐藏。点击任意中文段落即可展开 / 收起对应英文原文。

打开官方英文原文 ↗

译文由机器翻译生成,仅供理解参考;有疑问请以官方英文原文为准。

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.3 INFORMATION_SCHEMA 总表 / 28.3.49 INFORMATION_SCHEMA VIEW_TABLE_USAGE 表
中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 69%

28.3.49 INFORMATION_SCHEMA VIEW_TABLE_USAGE 表28.3.49 The INFORMATION_SCHEMA VIEW_TABLE_USAGE Table

VIEW_TABLE_USAGE 表提供了有关视图定义中使用的表和视图的信息。The VIEW_TABLE_USAGE table provides access to information about tables and views used in view definitions.

您只能查看您拥有某种权限的视图的信息,以及您拥有某种权限的表的信息。You can see information only for views for which you have some privilege, and only for tables for which you have some privilege.

VIEW_TABLE_USAGE 表包含如下列:The VIEW_TABLE_USAGE table has these columns:

  • VIEW_CATALOG

    视图所属目录的名称。此值始终为 def。The name of the catalog to which the view belongs. This value is always def.

  • VIEW_SCHEMA

    视图所属模式(数据库)的名称。The name of the schema (database) to which the view belongs.

  • VIEW_NAME

    视图的名称。The name of the view.

  • TABLE_CATALOG

    定义视图时使用的表或视图所属的目录名称。该值始终为 def。The name of the catalog to which the table or view used in the view definition belongs. This value is always def.

  • TABLE_SCHEMA

    定义视图时使用的表或视图所属的模式(数据库)名称。The name of the schema (database) to which the table or view used in the view definition belongs.

  • TABLE_NAMETABLE_NAME

    定义视图时使用的表或视图的名称。The name of the table or view used in the view definition.