Delete Data Masking Rule

 

Deletes a dynamic data masking rule for an Azure SQL Database.

Note

This feature is currently available only as a preview. The content related to this feature is preliminary.

Request

See Common parameters and headers for headers and parameters that are used by all SQL Database requests.

Method

Request URI

DELETE

https://management.azure.com/subscriptions/{subscription-id}/resourceGroups/{resource-group-name}/providers/Microsoft.Sql/servers/{server-name}/databases/{database-name}/dataMaskingPolicies/Default/rules/{rule-name}?api-version={api-version}

URI Parameters

None.

Request Headers

Standard request headers.

Request Body

None.

Response

The response includes an HTTP status code, and a set of response headers.

Status Code

200 OK – Indicates the request completed successfully. The rule existed and was successfully deleted.

204 No Content – The request was well formed but the rule does not exist.

404 Not Found – The data masking policy, server, or database does not exist.

4xx/5xx – an error occurred during the operation; the body will provide the standard error response.

Response Headers

Standard response headers

Response Body

None.

Possible standard error when status code returned is 4xx or 5xx.

See Also

Get started with SQL Database Dynamic Data Masking
Common REST API Error Codes
Azure SQL Database
Operations for Azure SQL Databases
Azure SQL Database Cmdlets