sp_query_store_remove_plan (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Removes a single plan from the Query Store.
Transact-SQL syntax conventions
Syntax
sp_query_store_remove_plan [ @plan_id = ] plan_id
[ ; ]
Arguments
Important
Arguments for extended stored procedures must be entered in the specific order as described in the Syntax section. If the parameters are entered out of order, an error message occurs.
[ @plan_id = ] plan_id
The ID of the query plan to be removed. @plan_id is bigint, with no default.
Return code values
0 (success) or 1 (failure).
Permissions
Requires the ALTER permission on the database.
Examples
The following example returns information about the queries in the Query Store.
SELECT txt.query_text_id,
txt.query_sql_text,
pl.plan_id,
qry.*
FROM sys.query_store_plan AS pl
INNER JOIN sys.query_store_query AS qry
ON pl.query_id = qry.query_id
INNER JOIN sys.query_store_query_text AS txt
ON qry.query_text_id = txt.query_text_id;
After you identify the plan_id that you want to delete, use the following example to delete a query plan.
EXEC sp_query_store_remove_plan 3;