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 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.
|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.|