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.

See Also

VIEW_COLUMNS