Help Center/ GaussDB/ Developer Guide(Centralized_8.x)/ System Catalogs and System Views/ System Catalogs/ Other System Catalogs/ GS_DEPENDENCIES
Updated on 2024-06-03 GMT+08:00
View PDF
Share

GS_DEPENDENCIES

The GS_DEPENDENCIES system catalog records object dependency information and has a one-to-many relationship with the GS_DEPENDENCIES_OBJ table.

Table 1 GS_DEPENDENCIES columns

Name

Type

Description

schemaname

name

Name of a namespace

packagename

name

Name of a package

refobjpos

integer

Position of the referenced object

  • 1: type
  • 2: package header
  • 4: function header
  • 8: function body
  • 16: package body
  • 32: view

refobjoid

oid

OID of the referenced object

objectname

text

Name of the dependent object
Parent topic: Other System Catalogs