sys.query_store_query_text (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

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. Comments and spaces before and after the query text are ignored. Comments and spaces inside text aren't ignored.
statement_sql_handle	varbinary(64)	SQL handle of the individual query.
is_part_of_encrypted_module 1	bit	Query text is a part of an encrypted module.
has_restricted_text 1	bit	Query text contains a password or other unmentionable words.

¹ Azure Synapse Analytics always returns zero (0).

Permissions

SQL Server 2019 (15.x) and previous versions require VIEW SERVER STATE permission on the server.

SQL Server 2022 (16.x) and later versions require VIEW SERVER PERFORMANCE STATE permission on the server.

Related content

• 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)
• Monitor performance by using the Query Store
• System catalog views (Transact-SQL)
• Query Store stored procedures (Transact-SQL)
• sys.fn_stmt_sql_handle_from_sql_stmt (Transact-SQL)