VIEWS
Provides information about all views within the system. See Views for more information.
Column Name | Data Type | Description |
---|---|---|
TABLE_SCHEMA_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the view schema. |
TABLE_SCHEMA
|
VARCHAR |
The name of the view schema. |
TABLE_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the view. |
TABLE_NAME
|
VARCHAR |
The view name. |
OWNER_ID
|
INTEGER |
A unique numeric ID assigned by the Vertica catalog, which identifies the view 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 Grant Inherited Privileges. |