VIEWS
Provides information about all within the system.
Provides information about all views within the system. See Views for more information.
| Column Name | Data Type | Description |
|---|---|---|
TABLE_SCHEMA_ID |
INTEGER | Catalog-assigned integer value that uniquely identifies theview schema. |
TABLE_SCHEMA |
VARCHAR | The name of the view schema. |
TABLE_ID |
INTEGER | Catalog-assigned integer value that uniquely identifies theview. |
TABLE_NAME |
VARCHAR | The view name. |
OWNER_ID |
INTEGER | Catalog-assigned integer value that uniquely identifies theview owner. |
OWNER_NAME |
VARCHAR | View owner's user name |
VIEW_DEFINITION |
VARCHAR | The query that defines the view. |
IS_SYSTEM_VIEW |
BOOLEAN | Indicates whether the view is a system view. |
SYSTEM_VIEW_CREATOR |
VARCHAR | View creator's user name. |
CREATE_TIME |
TIMESTAMP | Specifies when this view was created. |
IS_LOCAL_TEMP_VIEW |
BOOLEAN | Indicates whether this view is a temporary view stored locally. |
INHERIT_PRIVILEGES |
BOOLEAN | Indicates whether inherited privileges are enabled for this view. For details, see Setting privilege inheritance on tables and views. |