Edit

.drop stored_query_result command

  • Article

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

Related content