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

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