title: "sys.plan_guides (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "06/10/2016" ms.prod: "sql" ms.prod_service: "database-engine, sql-database" ms.service: "" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology:
- "database-engine" ms.tgt_pltfrm: "" ms.topic: "language-reference" f1_keywords:
- "sys.planguides_TSQL"
- "plan_guides"
- "sys.planguides"
- "plan_guides_TSQL" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.plan_guides catalog view" ms.assetid: 3dde0397-ef6f-4b3f-8250-3f25584eb62b caps.latest.revision: 24 author: "edmacauley" ms.author: "edmaca" manager: "craigg" ms.workload: "Inactive" monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2008-asdb-xxxx-xxx-md]
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. OBJECT SQL TEMPLATE |
| 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. |
[!INCLUDEssCatViewPerm] For more information, see Metadata Visibility Configuration.
Catalog Views (Transact-SQL)
sp_create_plan_guide (Transact-SQL)
sp_create_plan_guide_from_handle (Transact-SQL)