<code className=”samp”><em>custom_classifier</em></code>!DELETE_CATEGORY

See also:

Using custom classifiers to implement custom semantic categories

从实例中删除指定的语义类别及其相关的隐私类别、正则表达式和注释。

语法

<custom_classifier>!DELETE_CATEGORY( '<semantic_category>' )

实参

semantic_category

Specifies the identifier (name) for the semantic category that you added to the instance when calling the <code className=”samp”><em>custom_classifier</em></code>!ADD_REGEX method.

输出

返回一条状态消息，指示删除指定的语义类别。

访问控制要求

A role used to execute this operation must have the following privileges at a minimum:

Instance roleObjectNotes
custom_classifier!PRIVACY_USERThe custom classification instance.

调用此方法的账户角色必须在自定义分类器上被授予此实例角色。

默认情况下，用于创建实例的账户角色可以调用此方法。

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

使用说明

在单独的 SQL 语句中调用该方法（无需方法链接）。

示例

Delete a category from the medical_codes instance:

CALL medical_codes!DELETE_CATEGORY('IC_10_CODES');

返回：

+------------------------------+
|       DELETE_CATEGORY        |
+------------------------------+
| Deleted category IC_10_CODES |
+------------------------------+