.drop stored_query_result command
Applies to: ✅ Azure Data Explorer
Deletes an active stored query result.
Use .drop stored_query_result storedQueryResultName to delete an active stored query result created in the current database.
Use .drop stored_query_results by user UserPrincipalName to delete all active stored query results in the current database by the specified user principal.
Permissions
You must have Database Viewer permissions to delete stored query results in the database, and Database Admin permissions to delete stored query results created by specified user principals.
Syntax
.drop stored_query_result storedQueryResultName
.drop stored_query_results by user UserPrincipalName
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| StoredQueryResultName | string |
✔️ | Stored query result name that adheres to entity names rules. |
| UserPrincipalName | string |
The UPN of a specific user for which to return a list of queries. |
Returns
Returns information about deleted stored query results.
Example
.drop stored_query_results by user 'aadapp=c28e9b80-2808-bed525fc0fbb'
Output
| StoredQueryResultId | Name | DatabaseName | PrincipalIdentity | SizeInBytes | RowCount | CreatedOn | ExpiresOn |
|---|---|---|---|---|---|---|---|
| c522ada3-e490-435a-a8b1-e10d00e7d5c2 | Events | TestDB | aadapp=c28e9b80-2808-bed525fc0fbb | 104372 | 1000000 | 2020-10-07 14:26:49.6971487 | 2020-10-08 14:26:49.6971487 |
| 571f1a76-f5a9-49d4-b339-ba7caac19b46 | Traces | TestDB | aadapp=c28e9b80-2808-bed525fc0fbb | 5212 | 100000 | 2020-10-07 14:31:01.8271231 | 2020-10-08 14:31:01.8271231 |