Updated on 2025-05-29 GMT+08:00

GS_DEPENDENCIES

GS_DEPENDENCIES 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.