Share via


List the SQL Server Databases

 

Applies To: Windows Azure Pack

Retrieves a list the of SQL Server databases for the specified subscription.

Request

Replace <TenantAPI> with your Service Management API endpoint address. Replace <SubscriptionId> with the tenant subscription identifier.

Method

Request URI

HTTP version

GET

https://<TenantAPI>:30005/<SubscriptionId>/services/sqlservers/databases

HTTP/1.1

URI Parameters

None.

Request Headers

The following table describes required and optional request headers.

Request header

Description

Authorization: Bearer

Required. The authorization bearer token.

x-ms-principal-id

Required. The principal identifier.

x-ms-client-request-id

Optional. The client request identifier.

x-ms-client-session-id

Optional. The client session identifier.

x-ms-principal-liveid

Optional. The principal Live identifier.

Request Body

None.

Response

The response includes an HTTP status code, a set of response headers, and a response body.

Status Code

A successful operation returns status code 200 (OK).

Response Headers

The response for this operation includes standard HTTP headers. All standard headers conform to the HTTP/1.1 protocol specification.

Response Body

The following table describes the key elements of the response body:

Element name

Description

SqlDatabase

The retrieved list of databases. For more information, see SqlDatabase (Object).

See Also

SQL Server Resource Provider Database Interfaces