Updated on 2024-06-03 GMT+08:00

MY_DEPENDENCIES

MY_DEPENDENCIES displays the dependencies between objects that are accessible to the current user. This view exists in the PG_CATALOG and SYS schemas and all users can access this view.

Table 1 MY_DEPENDENCIES columns

Name

Type

Description

name

name

Object name.

type

character varying(18)

Object type.

referenced_owner

name

Owner of the referenced object.

referenced_name

name

Name of the referenced object.

referenced_type

character varying(18)

Type of the referenced object.

referenced_link_name

character varying(128)

Name of the link to the parent object (if remote).

dependency_type

character varying(4)

Specifies whether the dependency is an REF dependency.