.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.
Syntax
.show
stored_query_results
.show
stored_query_result
storedQueryResultName schema
Learn more about syntax conventions.
Parameters
Name | Type | Required | Description |
---|---|---|---|
StoredQueryResultName | string |
✔️ | Stored query result name that adheres to entity names rules. |
Returns
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.
Examples
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"}] |
Related content
משוב
https://aka.ms/ContentUserFeedback.
בקרוב: במהלך 2024, נפתור בעיות GitHub כמנגנון המשוב לתוכן ונחליף אותו במערכת משוב חדשה. לקבלת מידע נוסף, ראה:שלח והצג משוב עבור