Class QueryStoreSchema.QueryStoreQueryText

Namespace

LinqToDB.Tools.DataProvider.SqlServer.Schemas

Assembly

linq2db.Tools.dll

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.

See sys.query_store_query_text.

[Table(Schema = "sys", Name = "query_store_query_text", IsView = true)]
public class QueryStoreSchema.QueryStoreQueryText

Inheritance

object

QueryStoreSchema.QueryStoreQueryText

Extension Methods

Map.DeepCopy<T>(T)

Properties

HasRestrictedText

Query text contains a password or other unmentionable words.
Note: Azure Synapse Analytics will always return zero (0).

[Column("has_restricted_text")]
[NotNull]
public bool HasRestrictedText { get; set; }

Property Value

bool

IsPartOfEncryptedModule

Query text is a part of an encrypted module.
Note: Azure Synapse Analytics will always return zero (0).

[Column("is_part_of_encrypted_module")]
[NotNull]
public bool IsPartOfEncryptedModule { get; set; }

Property Value

bool

QuerySqlText

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.

[Column("query_sql_text")]
[Nullable]
public string? QuerySqlText { get; set; }

Property Value

string

QueryTextID

Primary key.

[Column("query_text_id")]
[NotNull]
public long QueryTextID { get; set; }

Property Value

long

StatementSqlHandle

SQL handle of the individual query.

[Column("statement_sql_handle")]
[Nullable]
public object? StatementSqlHandle { get; set; }

Property Value

object