Remove-SqlSensitivityClassification

Синтаксис

ByContext (по умолчанию)

Remove-SqlSensitivityClassification
    -ColumnName <String[]>
    [-SuppressProviderContextWarning]
    [<CommonParameters>]

ByConnectionString

Remove-SqlSensitivityClassification
    -ColumnName <String[]>
    -ConnectionString <String>
    [<CommonParameters>]

ByConnectionParameters

Remove-SqlSensitivityClassification
    -ColumnName <String[]>
    -ServerInstance <PSObject>
    -DatabaseName <String>
    [-Credential <PSCredential>]
    [<CommonParameters>]

ByPath

Remove-SqlSensitivityClassification
    -ColumnName <String[]>
    -Path <String>
    [<CommonParameters>]

ByDBObject

Remove-SqlSensitivityClassification
    -ColumnName <String[]>
    -InputObject <Database>
    [<CommonParameters>]

Описание

Примеры

Example 1: Remove sensitivity label and information type from a column using Windows authentication

PS C:\> Remove-SqlSensitivityClassification -ServerInstance "MyComputer\MainInstance" -Database "myDatabase" -ColumnName "Sales.Customers.email"

Example 2: Remove sensitivity label and information type from a column by providing a database path

PS C:\> Remove-SqlSensitivityClassification -Path "SQLSERVER:\SQL\MyComputer\MainInstance\Databases\MyDatabase" -ColumnName "Sales.Customers.email"

Example 3: Remove sensitivity labels and information types on multiple columns using current path context

PS C:\> $columns = @("Sales.Customers.ip_address" , "Sales.Customers.email")
PS C:\> Set-Location "SQLSERVER:\SQL\MyComputer\MainInstance\Databases\MyDatabase"
PS SQLSERVER:\SQL\MyComputer\MainInstance> Remove-SqlSensitivityClassification -ColumnName $columns
 WARNING: Using provider context. Server = MyComputer, Database = MyDatabase.

Параметры

-ColumnName

Name(s) of columns for which information type and sensitivity label is fetched.

Свойства параметра

Наборы параметров

-ConnectionString

Specifies a connection string to connect to the database. If this parameter is present, other connection parameters will be ignored

Свойства параметра

Наборы параметров

-Credential

Specifies a credential used to connect to the database.

Свойства параметра

Наборы параметров

-DatabaseName

Specifies the name of a database. This cmdlet connects to this database in the instance that is specified in the ServerInstance parameter.

If the DatabaseName parameter is not specified, the database that is used depends on whether the current path specifies both the SQLSERVER:\SQL folder and a database name. If the path specifies both the SQL folder and a database name, this cmdlet connects to the database that is specified in the path.

Свойства параметра

Наборы параметров

-InputObject

Specifies a SQL Server Management Object (SMO) that represent the database that this cmdlet uses.

Свойства параметра

Наборы параметров

-Path

Specifies the path to the instance of SQL Server on which this cmdlet runs the operation. If you do not specify a value for this parameter, the cmdlet uses the current working location.

Свойства параметра

Наборы параметров

-ServerInstance

Specifies either the name of the server instance (a string) or SQL Server Management Objects (SMO) object that specifies the name of an instance of the Database Engine. For default instances, only specify the computer name: MyComputer. For named instances, use the format ComputerName\InstanceName.

Свойства параметра

Наборы параметров

-SuppressProviderContextWarning

Indicates that this cmdlet suppresses the warning that this cmdlet has used in the database context from the current SQLSERVER:\SQL path setting to establish the database context for the cmdlet.

Свойства параметра

Наборы параметров

CommonParameters

Входные данные

System.String

Microsoft.SqlServer.Management.Smo.Database

Выходные данные

System.Object

Связанные ссылки

• What is new in SSMS 17.5: Data Discovery and Classification
• SQL Data Discovery and Classification