sys-query-store-query-text-transact-sql.md

title	sys.query_store_query_text (Transact-SQL)
description	sys.query_store_query_text (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	01/23/2019
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	SYS.QUERY_STORE_QUERY_TEXT QUERY_STORE_QUERY_TEXT SYS.QUERY_STORE_QUERY_TEXT_TSQL QUERY_STORE_QUERY_TEXT_TSQL
helpviewer_keywords	sys.query_store_query_text catalog view query_store_query_text catalog view
dev_langs	TSQL
ms.assetid	f7032fa0-7c16-4492-bb82-685806c63a8c
monikerRange	=azuresqldb-current||>=sql-server-2016||=azure-sqldw-latest||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.query_store_query_text (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asa]

Contains the [!INCLUDEtsql] 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 are not ignored.
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 Synapse Analytics will always return zero (0).
has_restricted_text	bit	Query text contains a password or other unmentionable words. Note: Azure Synapse Analytics will always return zero (0).

Permissions

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)