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 - Links
- OpenAPI document
How to test the Azure SQL: Databases in Swastik Codes
- Open the APISelect “Fork & run in Swastik Codes” on this page. Sign in or create a free account if asked.
- Fork it into your workspaceChoose a workspace. You get your own copy of the Azure SQL: Databases collection, without the publisher's secrets.
- 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.
- 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.