Updated on 2024-05-07 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 schema and all users can access this view.

Table 1 MY_DEPENDENCIES columns

Name

Type

Description

name

character varying(128)

Object name.

type

character varying(18)

Object type

referenced_owner

character varying(128)

Owner of the referenced object.

referenced_name

character varying(128)

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.