sys.query_store_query_text (Transact-SQL)

APPLIES TO: yesSQL Server (starting with 2016) yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

Contains the Transact-SQL text and the SQL handle of the query.

Column name Data type Description
query_text_id bigint Primary key.
query_sql_text nvarchar(max) SQL text of the query, as provided by the user. Includes whitespaces, hints and comments.
statement_sql_handle vabinary(64) SQL handle of the individual query.
is_part_of_encrypted_module bit Query text is a part of an encrypted module.
Note: Azure SQL Data Warehouse will always return zero (0).
has_restricted_text bit Query text contains a password or other unmentionable words.
Note: Azure SQL Data Warehouse will always return zero (0).


Requires the VIEW DATABASE STATE permission.

See Also

sys.database_query_store_options (Transact-SQL)
sys.query_context_settings (Transact-SQL)
sys.query_store_plan (Transact-SQL)
sys.query_store_query (Transact-SQL)
sys.query_store_runtime_stats (Transact-SQL)
sys.query_store_wait_stats (Transact-SQL)
sys.query_store_runtime_stats_interval (Transact-SQL)
Monitoring Performance By Using the Query Store
Catalog Views (Transact-SQL)
Query Store Stored Procedures (Transact-SQL)
sys.fn_stmt_sql_handle_from_sql_stmt (Transact-SQL)