sys.sp_query_store_remove_query

Description

2016 (13.x) and later versions SQL database in Microsoft Fabric Removes the query and all associated plans and runtime stats from the Query Store. The ID of the query to be removed from the Query Store. Requires the ALTER permission on the database. Arguments for extended stored procedures must be entered in the specific order as section.

Syntax

sp_query_store_remove_query [ @query_id = ] query_id
[ ; ]

Examples

Example 1

0

Example 2

1

Example 3

sp_query_store_remove_query [ @query_id = ] query_id
[ ; ]