qua_materialized_views#

Contains rows about each materialized view (cached view) in current database and physical table, that is used as a backend storage for the view.

Column name

Data type

Nullable?

Description

object_id

int

false

Object_id of the view. Can be used to join with sys.views.

persistent_object_name

nvarchar(500)

false

Physical object name created and used as a backend storage (usually a table).

connection_name

nvarchar(128)

false

Querona’s connection name used to store the physical object.

is_primary

bit

false

1 = physical object is currently used to serve the view data (is a primary one).

last_refresh

datetime

true

Date and time of the last, successfull materialization.

Example#

select *
  from sys.qua_materialized_views as qv