EXA_USER_VIEWS
This system table lists all views that are owned by the current user. All users 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 |