Skip to main content

sensitivity_labels_current_by_databases

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

Overview

Namesensitivity_labels_current_by_databases
TypeResource
Idazure.sql.sensitivity_labels_current_by_databases

Fields

NameDatatypeDescription
managedBystringResource that manages the sensitivity label.
propertiesobjectProperties of a sensitivity label.

Methods

NameAccessible byRequired ParamsDescription
listSELECTdatabaseName, resourceGroupName, serverName, subscriptionIdGets the sensitivity labels of a given database

SELECT examples

Gets the sensitivity labels of a given database

SELECT
managedBy,
properties
FROM azure.sql.sensitivity_labels_current_by_databases
WHERE databaseName = '{{ databaseName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';