System views

The topics in this section describe the system views.

Configuration

Configuration views.

• sys.configurations
• sys.time_zone_info

Jobs

The topics in this section describe the system tables that store information used by the job manager. All views are in the dbo schema.

Note that most of the tasks can also be achieved conveniently using Querona Administration Portal user interface.

• syscategories
• sysjobhistory
• sysjobs
• sysjobschedules
• sysschedules
• sys.extended_properties

Administrative

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.

View name	Description
qua_data_api_instances	Provides a detailed list of all configured DataApi instances.
qua_dm_memory_object_pools	Provides a list of all internal object pools.
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_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.