Querona-specific views

Apart from emulating SQL Server’s views, Querona introduces some of its own. All of them start with qua_ prefix to be easily distinguished from regular SQL Server views.

In general, these views should be used by software developers and administrators. Note that most of the tasks can also be achieved conveniently using Querona Admin Portal user interface.

Administrative

Administrative stored procedures should be used by power users and administrators. Note that most of the tasks can also be achieved conveniently using Querona Administration Portal user interface.

View name Description
qua_functions Provides list of functions supported by each Querona provider.
qua_materialized_views Contains rows about each materialized view (cached views) and their physical counterparts, that are used as a backend storage of the view.
qua_provider_tables Provides all tables that exist on a provider connection for a specific database. The view exists in _sys_ schema.
qua_recent_statements Provides list of recent SQL statements that were received and handled by Querona.