# Microsoft SQL Server Databases API

**Canonical:** https://apis.io/apis/microsoft-sql-server/microsoft-sql-server-databases-api/  
**Provider:** Microsoft SQL Server — https://apis.io/providers/microsoft-sql-server/  
**Base URL:** https://management.azure.com  
**Documentation:** https://docs.microsoft.com/sql/relational-databases/server-management-objects-smo/

Microsoft SQL Server Databases API is one of 32 APIs that [Microsoft SQL Server](https://apis.io/providers/microsoft-sql-server/) publishes on the [APIs.io](https://apis.io/) network, described by a machine-readable OpenAPI specification. Tagged areas include Databases. The published artifact set on APIs.io includes an OpenAPI specification, API documentation, an API reference, a getting-started guide, and pricing.

The Databases API from Microsoft SQL Server — 11 operation(s) for databases.

## Operations (14)

| Method | Path | Summary |
|---|---|---|
| GET | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases` | Databases list by server |
| GET | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}` | Databases get |
| PUT | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}` | Databases create or update |
| PATCH | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}` | Databases update |
| DELETE | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}` | Databases delete |
| POST | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/export` | Databases export |
| POST | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/failover` | Databases failover |
| POST | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/import` | Databases import |
| POST | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/move` | Databases rename |
| POST | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/pause` | Databases pause |
| POST | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/resume` | Databases resume |
| POST | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}/upgradeDataWarehouse` | Databases upgrade data warehouse |
| GET | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/elasticPools/{elasticPoolName}/databases` | Databases list by elastic pool |
| GET | `/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/inaccessibleDatabases` | Databases list inaccessible by server |

## Machine-readable artifacts (6)

- **OpenAPI** — https://artifacts.apis.io/microsoft-sql-server/openapi/microsoft-sql-server-databases-api-openapi.yml
- **Documentation** — https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/api-references-create-manage-instance
- **APIReference** — https://learn.microsoft.com/en-us/rest/api/sql/managed-instances
- **GettingStarted** — https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-create-quickstart
- **Pricing** — https://azure.microsoft.com/pricing/details/azure-sql-managed-instance/
- **APIReference** — https://learn.microsoft.com/en-us/rest/api/sql/

## Other Microsoft SQL Server APIs (12)

- [SQL Server Management Objects (SMO) API](https://apis.io/apis/microsoft-sql-server/sql-server-management-objects-smo-api/)
- [SQL Server Integration Services (SSIS) Catalog API](https://apis.io/apis/microsoft-sql-server/sql-server-integration-services-ssis-catalog-api/)
- [Data API Builder](https://apis.io/apis/microsoft-sql-server/data-api-builder/)
- [Azure Analysis Services REST API](https://apis.io/apis/microsoft-sql-server/azure-analysis-services-rest-api/)
- [Microsoft SqlClient Data Provider (ADO.NET)](https://apis.io/apis/microsoft-sql-server/microsoft-sqlclient-data-provider-ado-net/)
- [Microsoft JDBC Driver for SQL Server](https://apis.io/apis/microsoft-sql-server/microsoft-jdbc-driver-for-sql-server/)
- [Microsoft ODBC Driver for SQL Server](https://apis.io/apis/microsoft-sql-server/microsoft-odbc-driver-for-sql-server/)
- [Microsoft OLE DB Driver for SQL Server](https://apis.io/apis/microsoft-sql-server/microsoft-ole-db-driver-for-sql-server/)
- [Microsoft Python Driver for SQL Server (mssql-python)](https://apis.io/apis/microsoft-sql-server/microsoft-python-driver-for-sql-server-mssql-python/)
- [Node.js Driver for SQL Server (tedious)](https://apis.io/apis/microsoft-sql-server/node-js-driver-for-sql-server-tedious/)
- [Microsoft SQL Server Azure SQL Databases API](https://apis.io/apis/microsoft-sql-server/microsoft-sql-server-azure-sql-databases-api/)
- [Microsoft SQL Server Azure SQL Servers API](https://apis.io/apis/microsoft-sql-server/microsoft-sql-server-azure-sql-servers-api/)

## Tags

Databases

---

Profiled by [API Evangelist](https://apievangelist.com) and published on [APIs.io](https://apis.io/apis/microsoft-sql-server/microsoft-sql-server-databases-api/). The API's provider profile, Kin Score and agent-readiness rating are at https://apis.io/providers/microsoft-sql-server/.