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 |