title | description | ms.reviewer | ms.topic | ms.date |
---|---|---|---|---|
.show stored_query_results command |
Learn how to use the `.show stored_query_result` command to show information on active query results. |
mispecto |
reference |
05/23/2023 |
Shows information on active stored query results.
Use .show
stored_query_results
to show information about active stored query results in the current database.
Use .show
stored_query_result
storedQueryResultName schema
to show the schema of an active stored query result in the current database.
You must have Database Viewer permissions to run these commands.
.show
stored_query_results
.show
stored_query_result
storedQueryResultName schema
[!INCLUDE syntax-conventions-note]
Name | Type | Required | Description |
---|---|---|---|
StoredQueryResultName | string |
✔️ | Stored query result name that adheres to entity names rules. |
Returns information about active stored query results in the current database.
Note
Please note that there might be a short delay before recently created stored query results appear in the results.
The following example returns information about the stored query result Events
.
.show stored_query_results Events
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 |
The following example shows the schema of the stored query result Events
.
.show stored_query_result Events schema
Output
StoredQueryResult | Schema |
---|---|
Events | [{"Column":"ID","Type":"guid"},{"Column":"EventName","Type":"string"},{"Column":"Time","Type":"datetime"}] |