Each row in the SYSVIEW system view describes a view in the database.
You can find additional information about views in the SYSTAB system view. The underlying system table for this view is ISYSVIEW.
You can also use the sa_materialized_view_info system procedure for a readable format of the information for materialized views. Materialized views are only supported for SQL Anywhere tables in the IQ catalog store.
| Column Name | Data Type | Description |
|---|---|---|
| view_object_id | UNSIGNED BIGINT | The object ID of the view. |
| view_def | LONG VARCHAR | The definition (query specification) of the view. |
| mv_build_type | TINYINT | Currently unused. |
| mv_refresh_type | TINYINT | The refresh type defined for the view. Possible values are IMMEDIATE (1) and MANUAL (2). |
| mv_use_in_optimization | TINYINT | Whether the materialized view can be used during query optimization (0=cannot be used in optimization, 1=can be used in optimization) |
| mv_last_refreshed_at | TIMESTAMP | Indicates the local date and time that the materialized view was last refreshed. |
| mv_known_stale_at | TIMESTAMP | The local time at which the materialized view became stale. This value corresponds to the time at which one of the underlying base tables was detected as having changed. A value of 0 indicates that the view is either fresh, or that it has become stale but the database server has not marked it as such because the view has not been used since it became stale. Use the sa_materialized_view_info system procedure to determine the status of a materialized view. |
| mv_last_refreshed_tsn | UNSIGNED BIGINT | The sequence number assigned to the transaction that refreshed the materialized view. |
| mv_last_refreshed_at_utc | TIMESTAMP WITH TIME ZONE | Indicates the UTC date and time that the materialized view was last refreshed. |
| mv_known_stale_at_utc | TIMESTAMP WITH TIME ZONE | The UTC time at which the materialized view became stale. This value corresponds to the time at which one of the underlying base tables was detected as having changed. A value of 0 indicates that the view is either fresh, or that it has become stale but the database server has not marked it as such because the view has not been used since it became stale. Use the sa_materialized_view_info system procedure to determine the status of a materialized view. This column contains 0 when mv_last_refreshed_at is 0 and NULL when mv_last_refreshed_at is NULL. |
PRIMARY KEY (view_object_id)
FOREIGN KEY (view_object_id) references SYS.ISYSOBJECT (object_id) MATCH UNIQUE FULL