Microsoft Azure

Azure SQL: Databases

Provides create, read, update and delete functionality for Azure SQL Databases.

Data & analytics#openapi#cloud

Fork copies the collection into your workspace, without the publisher's secrets, so you can add your own key and send requests. Star saves it to your starred APIs (Account › Marketplace) and helps others find it.

Overview

Provides create, read, update and delete functionality for Azure SQL Databases.

Endpoints 11

DatabaseActivation

  • POSTDatabases_Pause/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/pausePauses a data warehouse.
  • POSTDatabases_Resume/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/resumeResumes a data warehouse.

Databases

  • GETDatabases_Get/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName?$expand=stringGets a database.
  • PUTDatabases_CreateOrUpdate/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseNameCreates a new database or updates an existing database.
  • DELETEDatabases_Delete/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseNameDeletes a database.
  • PATCHDatabases_Update/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseNameUpdates an existing database.
  • GETDatabases_ListByServer/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases?$expand=string&$filter=stringReturns a list of databases in a server.
  • GETDatabases_ListByElasticPool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/elasticPools/:elasticPoolName/databasesReturns a list of databases in an elastic pool.
  • GETDatabases_GetByRecommendedElasticPool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/recommendedElasticPools/:recommendedElasticPoolName/databases/:databaseNameGets a database inside of a recommended elastic pool.
  • GETDatabases_ListByRecommendedElasticPool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/recommendedElasticPools/:recommendedElasticPoolName/databasesReturns a list of databases inside a recommended elastic pool.

ElasticPools

  • GETDatabases_GetByElasticPool/subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/elasticPools/:elasticPoolName/databases/:databaseNameGets a database inside of an elastic pool.

API details

Base URL
https://management.azure.com
Authentication
OAuth 2.0 (implicit flow) with 1 scope
Operations
11 operations on 8 pathsGET 6POST 2PUT 1PATCH 1DELETE 1
Main resources
Databases 8DatabaseActivation 2ElasticPools 1
Response formats
application/json
Description format
Swagger 2.0, API version 2014-04-01

How to test the Azure SQL: Databases in Swastik Codes

  1. Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
  2. Fork it into your workspaceChoose a workspace. You get your own copy of the Azure SQL: Databases collection, without the publisher's secrets.
  3. Add your credentialsThis API uses OAuth 2.0 (implicit flow) with 1 scope. Add yours in the collection's variables or an environment; the requests already reference it.
  4. Send a requestPick an endpoint, for example “Databases_Pause” (POST /subscriptions/:subscriptionId/resourceGroups/:resourceGroupName/providers/Microsoft.Sql/servers/:serverName/databases/:databaseName/pause), and press Send. Check the response, add tests and run the whole collection with the runner.

Frequently asked questions

What is the Azure SQL: Databases?

Provides create, read, update and delete functionality for Azure SQL Databases. It is listed under Data & analytics and has 11 endpoints.

Who publishes the Azure SQL: Databases?

It is listed from Microsoft Azure's public API description (an OpenAPI document), not published by Microsoft Azure on Swastik Codes. Anyone who controls azure.com can claim the profile by adding a DNS TXT record.

What is the base URL of the Azure SQL: Databases?

Requests go to https://management.azure.com. Endpoint paths are added to this base URL.

How do I authenticate with the Azure SQL: Databases?

With OAuth 2.0 (implicit flow) with 1 scope.

How many endpoints does the Azure SQL: Databases have?

11 operations on 8 paths (6 GET, 2 POST, 1 PUT, 1 PATCH, 1 DELETE). The largest groups are Databases, DatabaseActivation, ElasticPools.

Is forking the Azure SQL: Databases free?

Yes. Forking copies the collection into your workspace for free. It has been starred 0 times and forked 0 times.

Suggest an API

Tell us which public API is missing. We check it, then add it here with its endpoints when it has an OpenAPI (Swagger) description.