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

GS_VIEW_INVALID

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

GS_VIEW_INVALID queries all unavailable views visible to the current user. If the base table, function, or synonym that the view depends on is abnormal, the validtype column of the view is displayed as "invalid".

Table 1 GS_VIEW_INVALID columns

Column

Type

Description

oid

oid

OID of the view

schemaname

name

View space name

viewname

name

Name of the view

viewowner

name

Owner of the view

definition

text

Definition of the view

validtype

text

View validity flag

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