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 alwaysdef.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 alwaysdef.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.