Skip to main content

recommended_sensitivity_labels

Creates, updates, deletes, gets or lists a recommended_sensitivity_labels resource.

Overview

Namerecommended_sensitivity_labels
TypeResource
Idazure.sql.recommended_sensitivity_labels

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
updateupdateresource_group_name, server_name, database_name, subscription_idUpdate recommended sensitivity labels states of a given database using an operations batch.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
database_namestringThe name of the database. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
server_namestringThe name of the server. Required.
subscription_idstring

UPDATE examples

Update recommended sensitivity labels states of a given database using an operations batch.

UPDATE azure.sql.recommended_sensitivity_labels
SET
operations = '{{ operations }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND server_name = '{{ server_name }}' --required
AND database_name = '{{ database_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required;