GS_VIEW_DEPENDENCY

GS_VIEW_DEPENDENCY allows you to query the direct dependencies of all views visible to the current user.

Table 1 GS_VIEW_DEPENDENCY columns

Column

Type

Description

objschema

name

View space name

objname

name

View name

refobjschema

name

Name of the space where the dependent object resides

refobjname

name

Name of a dependent object

relobjkind

char

Type of a dependent object

  • r: table

  • v: view