Views

The views system table includes information about the materialized views that have been created within your organization.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.information_schema.views;

The system.information_schema.views table includes the following columns:

Properties

The properties column comprises information about the options specified when the materialized view was created:

Last updated