SYS.VIEWS

The VIEWS table stores the statistics for views in the database.

Columns

Column name	Type	Description
NAME	TT_CHAR(31) NOT NULL	View name
OWNER	TT_CHAR(31) NOT NULL	View owner
ID	TT_BIGINT NOT NULL	ID of the view row
TBLID	TT_BIGINT NOT NULL	ID of the view
SQL	TT_VARCHAR(409600) NOT INLINE NOT NULL	View SELECT statement
GIXNAME	TT_CHAR(31) NOT NULL	An internal materialized view is created for each global index. This column contains the global index name for the materialized view.
REFRESH_INTERVAL	TT_BIGINT	Refresh interval in seconds
REFRESH_START	TT_TIMESTAMP	The start time of the most recent refresh
REFRESH_END	TT_TIMESTAMP	The ending time of the most recent refresh
REFRESH_ROWCNT	TT_INTEGER	Number of rows refreshed in the most recent refresh