Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
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.
.drop stored_query_result storedQueryResultName
.drop stored_query_results by user UserPrincipalName
Learn more about syntax conventions.
| 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 information about deleted stored query results.
.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 |