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.