Applies to: SQL Server (all supported versions) Azure SQL Database
Contains a row for each plan guide in the database.
|Column name||Data type||Description|
|plan_guide_id||int||Unique identifier of the plan guide in the database.|
|name||sysname||Name of the plan guide.|
|create_date||datetime||Date and time the plan guide was created.|
|modify_date||Datetime||Date the plan guide was last modified.|
|is_disabled||bit||1 = Plan guide is disabled.
0 = Plan guide is enabled.
|query_text||nvarchar(max)||Text of the query on which the plan guide is created.|
|scope_type||tinyint||Identifies the scope of the plan guide.
1 = OBJECT
2 = SQL
3 = TEMPLATE
|scope_type_desc||nvarchar(60)||Description of scope of the plan guide.
|scope_object_id||Int||object_id of the object defining the scope of the plan guide, if the scope is OBJECT.
NULL if the plan guide is not scoped to OBJECT.
|scope_batch||nvarchar(max)||Batch text, if scope_type is SQL.
NULL if batch type is not SQL.
If NULL and scope_type is SQL, the value of query_text applies.
|parameters||nvarchar(max)||The string defining the list of parameters associated with the plan guide.
NULL = No parameter list is associated with the plan guide.
|hints||nvarchar(max)||The OPTION clause hints associated with the plan guide.|
The visibility of the metadata in catalog views is limited to securables that a user either owns or on which the user has been granted some permission. For more information, see Metadata Visibility Configuration.