MySQL :: MySQL 8.4 参考手册 :: 28.3.48 INFORMATION_SCHEMA VIEW_ROUTINE

MySQL 8.4 参考手册 · 中文镜像

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

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

MySQL 8.4 参考手册 / 28 个 INFORMATION_SCHEMA 表 / 28.3 INFORMATION_SCHEMA 总表 / 28.3.48 INFORMATION_SCHEMA VIEW_ROUTINE_USAGE 表

中文点击中文段落可显示 / 隐藏英文原文本页译文覆盖 69%

28.3.48 INFORMATION_SCHEMA VIEW_ROUTINE_USAGE 表28.3.48 The INFORMATION_SCHEMA VIEW_ROUTINE_USAGE Table

VIEW_ROUTINE_USAGE 表提供有关在视图定义中使用的存储函数的信息。该表不列出在定义中使用的内置（本地）函数或可加载函数的信息。The VIEW_ROUTINE_USAGE table provides access to information about stored functions used in view definitions. The table does not list information about built-in (native) functions or loadable functions used in the definitions.

您只能查看您拥有某些权限的视图的信息，以及您对其具有某些权限的函数的信息。You can see information only for views for which you have some privilege, and only for functions for which you have some privilege.

VIEW_ROUTINE_USAGE 表具有以下列：The VIEW_ROUTINE_USAGE table has these columns:

TABLE_CATALOG
视图所属目录的名称。此值始终为 def。The name of the catalog to which the view belongs. This value is always def.
TABLE_SCHEMA
视图所属模式（数据库）的名称。The name of the schema (database) to which the view belongs.
TABLE_NAMETABLE_NAME
视图的名称。The name of the view.
SPECIFIC_CATALOG
函数所属目录的名称，该函数在视图定义中使用。此值始终为 def。The name of the catalog to which the function used in the view definition belongs. This value is always def.
SPECIFIC_SCHEMA
视图定义中使用的函数所属的模式（数据库）名称。The name of the schema (database) to which the function used in the view definition belongs.
SPECIFIC_NAME
视图定义中使用的函数名称。The name of the function used in the view definition.

首页上一级下一节