تحرير

Remove-AzSqlInstanceDatabaseSensitivityClassification

  • Reference
Module:
Az.Sql

Removes the information types and sensitivity labels of columns in the Azure SQL Managed Instance database.

Note

This is the previous version of our documentation. Please consult the most recent version for up-to-date information.

Syntax

Remove-AzSqlInstanceDatabaseSensitivityClassification
      -ClassificationObject <ManagedDatabaseSensitivityClassificationModel>
      [-PassThru]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Remove-AzSqlInstanceDatabaseSensitivityClassification
      [-ResourceGroupName] <String>
      [-InstanceName] <String>
      [-DatabaseName] <String>
      -SchemaName <String>
      -TableName <String>
      -ColumnName <String>
      [-PassThru]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]
Remove-AzSqlInstanceDatabaseSensitivityClassification
      -DatabaseObject <AzureSqlManagedDatabaseModel>
      -SchemaName <String>
      -TableName <String>
      -ColumnName <String>
      [-PassThru]
      [-AsJob]
      [-DefaultProfile <IAzureContextContainer>]
      [-WhatIf]
      [-Confirm]
      [<CommonParameters>]

Description

The Remove-AzSqlInstanceDatabaseSensitivityClassification cmdlet removes the information types and sensitivity labels of columns in the Azure SQL Managed Instance database.

Examples

Example 1: Remove information type and sensitivity label of a column in an Azure SQL Managed Instance database.

PS C:\> Remove-AzSqlInstanceDatabaseSensitivityClassification -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database -SchemaName schema -TableName table -ColumnName column

Example 2: Remove current information types and sensitivity labels of columns in an Azure SQL Managed Instance database with Piping.

PS C:\> Get-AzSqlInstanceDatabaseSensitivityClassification -ResourceGroupName resourceGroup -InstanceName managedInstance -DatabaseName database | Remove-AzSqlInstanceDatabaseSensitivityClassification

Example 3: Remove information type and sensitivity label of a column in an Azure SQL Managed Instance database with Piping.

PS C:\> Get-AzSqlInstanceDatabase -ResourceGroupName resourceGroup -InstanceName managedInstance -Name database | Remove-AzSqlInstanceDatabaseSensitivityClassification -SchemaName schema -TableName table -ColumnName column

Parameters

-AsJob

Run cmdlet in the background

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ClassificationObject

An object representing a SQL Managed Instance Database Sensitivity Classification.

Type:ManagedDatabaseSensitivityClassificationModel
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-ColumnName

Name of column.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-Confirm

Prompts you for confirmation before running the cmdlet.

Type:SwitchParameter
Aliases:cf
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-DatabaseName

The name of the Azure SQL Managed Instance database.

Type:String
Position:2
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-DatabaseObject

The Azure SQL Managed Instance database object.

Type:AzureSqlManagedDatabaseModel
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-DefaultProfile

The credentials, account, tenant, and subscription used for communication with Azure.

Type:IAzureContextContainer
Aliases:AzContext, AzureRmContext, AzureCredential
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-InstanceName

Azure SQL Managed Instance name.

Type:String
Position:1
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-PassThru

Specifies whether to output the sensitivity classification model at end of cmdlet execution

Type:SwitchParameter
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False
-ResourceGroupName

The name of the resource group.

Type:String
Position:0
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-SchemaName

Name of schema.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-TableName

Name of table.

Type:String
Position:Named
Default value:None
Accept pipeline input:True
Accept wildcard characters:False
-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Type:SwitchParameter
Aliases:wi
Position:Named
Default value:None
Accept pipeline input:False
Accept wildcard characters:False

Inputs

ManagedDatabaseSensitivityClassificationModel

Outputs

Boolean