System stored procedures#
Apart from emulating SQL Server’s stored procedures, Querona introduces some of its own.
All of them start with qua_ prefix to be easily distinguished from system stored procedures known from SQL Server.
Querona groups its system stored procedures as below. Follow a link for the procedures in each group.
Group |
Description |
|---|---|
Power-user and administrator procedures (plan cache, GC, default federator, log cleanup). |
|
Manage materialized (cached) views and their physical storage. |
|
Create, test and manage connections (linked servers). |
|
Change the logging level and inspect jobs. |
|
Add, update and drop extended properties on database objects. |
|
Define and control scheduler jobs, steps and schedules. |
|
Inspect and generate metadata, and describe result sets. |
|
Query Store maintenance. |
|
Control the Apache Spark driver and instances. |
|
Statistics maintenance, provider-SQL execution and log processing. |
SQL Server Legacy#
The following internal stored procedures are internally supported by Querona engine for compatibility with TDS protocol and technologies like OLEDB:
Procedure name |
Description |
|---|---|
sp_prepare |
Prepares a parameterized Transact-SQL statement and returns a statement handle for execution. |
sp_prepexec |
Prepares and executes a parameterized Transact-SQL statement. |
sp_execute |
Executes a prepared Transact-SQL statement using a specified handle and optional parameter value. |
sp_unprepare |
Discards the execution plan created by the sp_prepare stored procedure. |
sp_executesql |
Executes a Transact-SQL statement or batch that can be reused many times, or one that has been built dynamically. |
sp_columns |
Returns column information for the specified objects that can be queried in the current environment. |
sp_special_columns |
Returns the optimal set of columns that uniquely identify a row in the table. |
sp_tables |
Returns a list of objects that can be queried in the current environment. |
sp_statistics |
Returns a list of all indexes and statistics on a specified table or indexed view. |
sp_fkeys |
Returns logical foreign key information for the current environment. |
sp_pkeys |
Returns primary key information for a single table. |
sp_describe_undeclared_parameters |
Returns a result set that contains metadata about undeclared parameters in a Transact-SQL batch. |
sp_changeobjectowner |
Changes the owner of an object in the current database. |
xp_msver |
Returns version information compatible with Microsoft SQL Server. |
Honorable mentions#
The following stored procedures are internally supported by Querona engine, but are not directly usable from queries:
sp_catalogs_rowset
sp_catalogs_rowset
sp_catalogs_rowset
sp_catalogs_rowset2
sp_columns_100
sp_columns_100_rowset
sp_columns_100_rowset2
sp_columns_rowset
sp_columns_rowset
sp_columns_rowset
sp_columns_rowset2
sp_columns_managed
sp_indexes_rowset
sp_indexes_rowset
sp_indexes_rowset
sp_indexes_rowset2
sp_indexcolumns_managed
sp_tableswc
sp_tables_info_rowset
sp_tables_info_rowset
sp_tables_info_rowset2
sp_statistics_100
sp_statistics_rowset
sp_statistics_rowset
sp_statistics_rowset2
sp_oledb_database
sp_oledb_ro_usrname
sp_oledb_defdb
sp_oledb_deflang
sp_oledb_language
sp_views_rowset
sp_views_rowset2
sp_schemata_rowset
sp_schemata_rowset
sp_tables_rowset
sp_tables_rowset
sp_tables_rowset
sp_tables_rowset2
sp_primary_keys_rowset
sp_primary_keys_rowset
sp_primary_keys_rowset
sp_primary_keys_rowset
sp_primary_keys_rowset2
sp_provider_types_100_rowset
sp_provider_types_90_rowset
sp_provider_types_rowset
sp_reset_connection
sp_foreign_keys_rowset
sp_foreign_keys_rowset
sp_foreign_keys_rowset
sp_foreign_keys_rowset
sp_foreign_keys_rowset2
sp_foreign_keys_rowset3
sp_procedures_rowset
sp_procedures_rowset
sp_procedures_rowset2
xp_qv
xp_instance_regread
xp_regread