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