Help Center > > Developer Guide> System Catalogs and System Views> System Views> GS_VIEW_DEPENDENCY_PATH

GS_VIEW_DEPENDENCY_PATH

Updated at: Sep 17, 2021 GMT+08:00

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel