st query
[This document supports a preliminary release of a software product that may be changed substantially prior to final commercial release. This document is provided for informational purposes only.]
Queries specified authority or container. If authority scope is specified, it returns all containers satisfying the query condition. If container scope is specified, it returns all entities in the specified container satisfying the query criteria.
st query [authorityid] [<containerid>] <queryText>
<credentials>
[/REST | /SOAP]
[/parallel:<number>] [/verbose]
Examples
Examples of the query command are given below. For more information on queries, see Querying SQL Data Services.
Example 1 Retrieve all authorities
The following command retrieves all authorities you created.
cmdPrompt>st query "from e in entities select e" /host:data.database.windows.net /user:username
Example 2 Retrieve all containers in an authority
The following command retrieves metadata for all containers in myauth authority.
cmdPrompt>st query myauth "from e in entities select e" /host:data.database.windows.net /user:username
Example 3 Retrieve all entities in a container
The following command retrieves all entities in container c1 in myauth authority. If the container has blob entities, it returns blob metadata. The blobs are not retrieved.
cmdPrompt>st query myauth c1 "from e in entities select e" /host:data.database.windows.net /user:username