This system table lists all views in the database. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.
| Column Name | Description |
|---|---|
VIEW_SCHEMA
|
Name of the schema in which the view was created |
VIEW_NAME
|
Name of the view |
SCOPE_SCHEMA
|
Schema that was explicitly opened by means of a connection parameter or OPEN SCHEMA command before view creation |
VIEW_OWNER
|
Owner of the view |
VIEW_OBJECT_ID
|
Internal ID of the view |
VIEW_TEXT
|
Text of the view, with which it was created |
VIEW_COMMENT
|
Comment on the view |
