EXA_USER_VIEWS
The system table lists all views 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 from which the view was created |
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 |