sys.sp_query_store_remove_plan

general

#stored-procedure

Description

2016 (13.x) and later versions SQL database in Microsoft Fabric Removes a single plan from the Query Store. The ID of the query plan to be removed. Requires the ALTER permission on the database. The following example returns information about the queries in the Query Store. Arguments for extended stored procedures must be entered in the specific order as section.

Syntax

sp_query_store_remove_plan [ @plan_id = ] plan_id
[ ; ]

Examples

Example 1

Example 2

Example 3

sp_query_store_remove_plan [ @plan_id = ] plan_id
[ ; ]