Create an Azure SQL Database using the REST API

  • Article

This how-to shows how to create a new Azure SQL Database using the Azure REST API.

Complete reference documentation and additional samples are available in the Azure SQL Database REST reference.

Build the request

Use the following HTTP PUT request to create a new Azure SQL Database.

PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=2017-10-01-preview

Request headers

The following headers are required:

Request header Description
Content-Type: Required. Set to application/json.
Authorization: Required. Set to a valid Bearer access token.

URI parameters

Name Description
subscriptionId The subscription ID that identifies an Azure subscription. If you have multiple subscriptions, see Working with multiple subscriptions
resourceGroupName The name of the resource group that contains the resource. You can obtain this value from the Azure Resource Manager API, CLI, or the portal.
serverName The name of the Azure SQL Database server.
databaseName The name of the database.
api-version The API version to use for the request.

This document covers api-version 2017-10-01-preview, included in the above URL.
   

Request body

The only required parameter is location. Use optional parameters to customize the database.

Name Type Description
location string Resource location. Get a current list of locations using the List Locations operation.

Handle the response

Status code 201 is returned when successfully creating the database. A full list of response codes, including error codes, are available in the reference documentation.

Example response

{
  "sku": {
    "name": "S0",
    "tier": "Standard"
  },
  "kind": "v12.0,user",
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS",
    "maxSizeBytes": 1073741824,
    "status": "Online",
    "databaseId": "6c764297-577b-470f-9af4-96d3d41e2ba3",
    "creationDate": "2017-06-07T04:41:33.937Z",
    "currentServiceObjectiveName": "S0",
    "defaultSecondaryLocation": "North Europe",
    "catalogCollation": "SQL_Latin1_General_CP1_CI_AS"
  },
  "location": "southeastasia",
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/Default-SQL-SouthEastAsia/providers/Microsoft.Sql/servers/testsvr/databases/testdb",
  "name": "testdb",
  "type": "Microsoft.Sql/servers/databases"
}