Azure SQL Database REST API 2014-04-01 Retirement Notice
We’re constantly making updates to Azure SQL APIs to ensure optimal security and performance. Therefore, we’ll be retiring following 2014-04-01 Azure SQL DB APIs on 31 October 2025. To minimize service disruption, please upgrade to a newer version or remove the usage of these older version Azure SQL DB APIs.
Stable API Mappings From 2014-04-01 to 2021-11-01
* APIs marked as deprecated with no newer/stable versions, are permanently discontinued from the service. Please reevaluate your usage scenarios for these APIs.
Latest Stable Version of Azure SQL Database REST API
| 2021-11-01 API Operation Group | Description |
|---|---|
| Backup Short Term Retention Policies | Create, get, update, list a database's short term retention policy. |
| Capabilities | Get the subscription capabilities available for the specified location. |
| Data Masking Policies | Creates, updates, get a database data masking policy. |
| Data Masking Rules | Creates, updates, list a database data masking rule. |
| Data Warehouse User Activities | Get and list the user activities of a data warehouse which includes running and suspended queries. |
| Database Advanced Threat Protection Settings | Create, get, update, list a database's Advanced Threat Protection state |
| Database Advisors | Get and list database advisors. |
| Database Automatic Tuning | Get and update a database's automatic tuning. |
| Database Blob Auditing Policies | Create, get, update, list a database's blob auditing policy. |
| Database Columns | Get and list database columns. |
| Database Extensions | Perform a database extension operation, like polybase import. |
| Database Operations | Get a list of operations performed on the database or cancels the asynchronous operation on the database. |
| Database Recommended Actions | Get and update a database recommended action. |
| Database Schemas | Get and list database schemas. |
| Database Security Alert Policies | Create, get, update, list a database's security alert policy. |
| Database Tables | Get and list database tables. |
| Database Usages | Get database usages. |
| Database Vulnerability Assessment Rule Baselines | Create, get, update, list, delete the database's vulnerability assessment rule baseline. |
| Database Vulnerability Assessment Scans | Get, list, execute, export the vulnerability assessment scans of a database. |
| Database Vulnerability Assessments | Create, get, update, list, delete the database's vulnerability assessment. |
| Databases | Create, get, update, list, delete, import, export, rename, pause, resume, upgrade SQL databases. |
| Deleted Servers | Get, list, recover the deleted servers. |
| Distributed Availability Groups | Creates, updates, list, get, delete a distributed availability group between Sql On-Prem and Sql Managed Instance. |
| Elastic Pool Operations | Gets a list of operations performed on the elastic pool or cancels the asynchronous operation on the elastic pool. |
| Elastic Pools | Create, get, update, delete, failover the elastic pools. |
| Encryption Protectors | Get, update, list, revalidate the existing encryption protectors. |
| Endpoint Certificates | Get and list the certificates used on endpoints on the target instance. |
| Extended Database Blob Auditing Policies | Create, get, update, list an extended database's blob auditing policy. |
| Extended Server Blob Auditing Policies | Create, get, update, list an extended server's blob auditing policy. |
| Failover Groups | Create, get, update, list, delete, and failover a failover group. |
| Firewall Rules | Create, get, update, delete, list firewall rules. |
| Geo Backup Policies | Create, update, get, list a database default Geo backup policy. |
| Instance Failover Groups | Create, get, update, list, delete, and failover an instance failover group. |
| Instance Pools | Create, get, update, list, delete the instance pools. |
| IP V6 Firewall Rules | Creates, updates, get, list, delete an IPv6 firewall rule. |
| Job Agents | Create, get, update, list, delete the job agents. |
| Job Credentials | Create, get, update, list, delete the job credentials. |
| Job Executions | Create, get, update, list, cancel the job executions. |
| Job Step Executions | Get and list the step executions of a job execution. |
| Job Steps | Create, get, update, list, delete job steps for a job's current version. |
| Job Target Executions | Get or list the target executions of a job step execution. |
| Job Target Groups | Create, get, update, list, delete the job target groups. |
| Job Versions | Get or list job versions. |
| Jobs | Create, get, update, list, delete jobs. |
| Ledger Digest Uploads | Create, get, update, list the ledger digest upload configuration for a database. |
| Long Term Retention Backups | Create, get, update, list, delete a long term retention backup. |
| Long Term Retention Managed Instance Backups | Create, get, update, list, delete a long term retention backup for a managed database. |
| Long Term Retention Policies | Get, list, set a database's long term retention policy. |
| Maintenance Window Options | Gets a list of available maintenance windows. |
| Maintenance Windows | Get or set maintenance windows settings for a database. |
| Managed Backup Short Term Retention Policies | Create, get, update, list a managed database's short term retention policy. |
| Managed Database Columns | Get or list managed database columns. |
| Managed Database Queries | Get query or query execution statistics by query id of a managed database. |
| Managed Database Recommended Sensitivity Labels | Update recommended sensitivity labels states of a given database using an operations batch. |
| Managed Database Restore Details | Get managed database restore details. |
| Managed Database Schemas | Get or list managed database schemas. |
| Managed Database Security Alert Policies | Create, get, update, list the managed database security alert policies. |
| Managed Database Security Events | Get a list of managed database security events. |
| Managed Database Sensitivity Labels | Create, get, update, list the sensitivity labels of a given database. Or enable or disable sensitivity recommendations on a given column. |
| Managed Database Tables | Get or list managed database tables. |
| Managed Database Transparent Data Encryption | Create, get, update, list a managed database's transparent data encryption. |
| Managed Database Vulnerability Assessment Rule Baselines | Create, get, update, list a managed database's vulnerability assessment rule baseline. |
| Managed Database Vulnerability Assessment Scans | Get, list, execute, export a managed database's vulnerability assessment scans. |
| Managed Database Vulnerability Assessments | Create, get, update, list, delete a managed database's vulnerability assessments. |
| Managed Databases | Create, get, update, list, delete, restore the managed databases. |
| Managed Instance Administrators | Create, get, update, list, delete managed instance administrators. |
| Managed Instance Azure AD Only Authentications | Get, set, list, delete the existing server Active Directory only authentication properties. |
| Managed Instance Encryption Protectors | Get, update, list, revalidate the existing encryption protectors of a managed instance. |
| Managed Instance Keys | Create, get, update, list, delete the managed instance keys. |
| Managed Instance Long Term Retention Policies | Create, get, list, update the managed instance's long term retention policies. |
| Managed Instance Operations | Get, list, cancel the operations performed on the managed instance. |
| Managed Instance Private Endpoint Connections | Create, get, list, update, delete the private endpoint connections on a managed instance. |
| Managed Instance Private Link Resources | Get or list the private link resources on the managed instance. |
| Managed Instance Tde Certificates | Create a Transparent Data Encryption certificate for a given managed instance. |
| Managed Instance Vulnerability Assessments | Create, get, list, update, delete the managed instance's vulnerability assessment policies. |
| Managed Instances | Create, get, update, list, delete, failover the managed instances. |
| Managed Restorable Dropped Database Backup Short Term Retention Policies | Create, get, update, list the managed restorable dropped database's short term retention policies. |
| Managed Server Dns Aliases | Create, get, list, acquire a managed server DNS alias. |
| Managed Server Security Alert Policies | Create, get, list, update the managed server's security alert policies. |
| Operations | List all of the available SQL Database REST API operations. |
| Outbound Firewall Rules | Create, get, update, list, delete the outbound firewall rules. |
| Private Endpoint Connections | Create, get, update, list, delete the private endpoint connections on a server. |
| Private Link Resources | Get or list the private link resources for SQL server. |
| Recommended Sensitivity Labels | Update recommended sensitivity labels states of a given database using an operations batch. |
| Recoverable Databases | Get a recoverable database, or list all recoverable databases for a server. |
| Recoverable Managed Databases | Get or list recoverable managed databases. |
| Replication Links | Get, list, delete, and failover replication links. |
| Restorable Dropped Databases | Get or list restorable dropped databases. |
| Restorable Dropped Managed Databases | Get or list restorable dropped managed databases. |
| Restore Points | Create, get, update, list, delete database restore points. |
| Sensitivity Labels | Create, get, update, list the sensitivity labels of a given database. Or enable or disable sensitivity recommendations on a given column. |
| Server Advanced Threat Protection Settings | Create, get, update, list the server's Advanced Threat Protection states. |
| Server Advisors | Get, list, update server advisors. |
| Server Automatic Tuning | Get or update automatic tuning options on server. |
| Server Azure AD Administrators | Create, get, list, update, delete Azure Active Directory administrators in a server. |
| Server Azure AD Only Authentications | Create, get, list, update, delete server Active Directory only authentication property. |
| Server Blob Auditing Policies | Create, get, update, list an extended server or database's blob auditing policy. |
| Server Connection Policies | Create, update, get, list a server connection policy. |
| Server DevOps Audit Settings | Create, get, list, update DevOps audit settings of a server. |
| Server Dns Aliases | Create, get, list, acquire or delete a server DNS alias. |
| Server Keys | Create, get, list, update, delete server keys. |
| Server Operations | Get a list of operations performed on the server. |
| Server Security Alert Policies | Create, get, list, update a server's security alert policies. |
| Server Trust Certificates | Create, get, list, update, delete server trust certificates. |
| Server Trust Groups | Create, get, list, update, delete server trust groups. |
| Server Usages | Get server usages. |
| Server Vulnerability Assessments | Create, get, list, update, delete the server vulnerability assessment policies. |
| Servers | Create, get, update, list, delete information about an Azure SQL server. and determine whether a resource can be created with the specified name. |
| Sql Agent | Get or set the sql agent configuration to instance. |
| Subscription Usages | Get or list the subscription usage metrics. |
| Sync Agents | Create, get, list, update, delete the sync agents. Or generate a sync agent key. |
| Sync Groups | Create, get, list, update, delete the sync groups. Or refreshes a hub database schema. |
| Sync Members | Create, get, list, update, delete the sync members. |
| Tde Certificates | Create a Transparent Data Encryption certificate for a given server. |
| Time Zones | Get or list the managed instance time zones. |
| Transparent Data Encryptions | Create, get, list, update a logical database's transparent data encryption configurations. |
| Usages | Gets all instance pool usage metrics. |
| Virtual Clusters | Create, get, list, update, delete the virtual clusters. |
| Virtual Network Rules | Create, get, list, update, delete the virtual network rules. |
| Workload Classifiers | Create, get, list, update, delete the workload classifiers. |
| Workload Groups | Create, get, list, update, delete the workload groups. |