az sql db classification
Manage sensitivity classifications.
Commands
Name | Description | Type | Status |
---|---|---|---|
az sql db classification delete |
Delete the sensitivity classification of a given column. |
Core | GA |
az sql db classification list |
Get the sensitivity classifications of a given database. |
Core | GA |
az sql db classification recommendation |
Manage sensitivity classification recommendations. |
Core | GA |
az sql db classification recommendation disable |
Disable sensitivity recommendations for a given column (recommendations are enabled by default on all columns). |
Core | GA |
az sql db classification recommendation enable |
Enable sensitivity recommendations for a given column (recommendations are enabled by default on all columns). |
Core | GA |
az sql db classification recommendation list |
List the recommended sensitivity classifications of a given database. |
Core | GA |
az sql db classification show |
Get the sensitivity classification of a given column. |
Core | GA |
az sql db classification update |
Update a columns's sensitivity classification. |
Core | GA |
az sql db classification delete
Delete the sensitivity classification of a given column.
az sql db classification delete --column
--schema
--table
[--ids]
[--name]
[--resource-group]
[--server]
[--subscription]
Examples
Delete the sensitivity classification of a given column.
az sql db classification delete -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn
Required Parameters
The name of the column.
The name of the schema.
The name of the table.
Optional Parameters
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Name of the Azure SQL Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az sql db classification list
Get the sensitivity classifications of a given database.
az sql db classification list [--count]
[--filter]
[--ids]
[--name]
[--resource-group]
[--server]
[--skip-token]
[--subscription]
Examples
List the sensitivity classification of a given database.
az sql db classification list -g mygroup -s myserver -n mydb
Optional Parameters
Default value is None.
An OData filter expression that filters elements in the collection. Default value is None.
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Name of the Azure SQL Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>
.
Default value is None.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az sql db classification show
Get the sensitivity classification of a given column.
az sql db classification show --column
--schema
--table
[--ids]
[--name]
[--resource-group]
[--server]
[--subscription]
Examples
Get the sensitivity classification of a given column.
az sql db classification show -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn
Required Parameters
The name of the column.
The name of the schema.
The name of the table.
Optional Parameters
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Name of the Azure SQL Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
az sql db classification update
Update a columns's sensitivity classification.
az sql db classification update --column
--schema
--table
[--ids]
[--information-type]
[--label]
[--name]
[--resource-group]
[--server]
[--subscription]
Examples
Update sensitivity classification for a given column.
az sql db classification update -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn --information-type Name --label "Confidential - GDPR"
Required Parameters
The name of the column.
The name of the schema.
The name of the table.
Optional Parameters
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
The information type.
The label name.
Name of the Azure SQL Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL Server. You can configure the default using az configure --defaults sql-server=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Global Parameters
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Azure CLI