sp_query_store_remove_query (Transact-SQL)
Applies to: 
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
Removes the query and all associated plans and runtime stats from the Query Store.
Transact-SQL syntax conventions
Syntax
sp_query_store_remove_query [ @query_id = ] query_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.
[ @query_id = ] query_id
The ID of the query to be removed from the Query Store. @query_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 query_id that you want to delete, use the following example to delete the query.
EXEC sp_query_store_remove_query 3;