.show stored_query_result command

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.

Permissions

You must have Database Viewer permissions to run these commands.

.show stored_query_results

.show stored_query_result storedQueryResultName schema

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"}]