Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ MY_DEPENDENCIES
Updated on 2025-08-19 GMT+08:00
View PDF

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.
Parent topic: Other System Views