Updated on 2023-04-14 GMT+08:00

GS_VIEW_DEPENDENCY_PATH

GS_VIEW_DEPENDENCY_PATH allows you to query the direct dependencies of all views visible to the current user. If the base table on which the view depends exists and the dependency between views at different levels is normal, you can use this view to query the dependency between views at different levels starting from the base table.

Table 1 GS_VIEW_DEPENDENCY_PATH 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

path

text

Dependency path