Updated on 2024-05-07 GMT+08:00

GS_DEPENDENCIES

GS_DEPENDENCIES records object dependency information and has a one-to-many relationship with 12.2.13 GS_DEPENDENCIES_OBJ.

Table 1 GS_DEPENDENCIES columns

Name

Type

Description

schemaname

name

Name of a namespace

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