Administrative 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 Web GUI.

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

View name	Description
qua_data_api_instances	Provides a detailed list of all configured DataApi instances.
qua_functions	Provides a list of functions supported by each data 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_object_pools	Provides a list of all internal object pools.
qua_provider_tables	Provides a list all tables that exist on a provider connection for a specific database. The view exists in _sys_ schema.
qua_recent_statements	Provides a list of recent SQL statements that were received and processed.