custom_classifier!DELETE_CATEGORY

See also:

Using custom classifiers

Deletes the specified semantic category with its associated privacy category, regular expression, and comment from the instance.

Syntax

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

Arguments

semantic_category

Specifies the identifier (name) for the semantic category that you added to the instance when calling the custom_classifier!ADD_REGEX method.

Output

Returns a status message indicating the deletion of the specified semantic category.

Access control requirements

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

Instance role

Object

Notes

custom_classifier!PRIVACY_USER

The custom classification instance.

The account role that calls this method must be granted this instance role on the custom classifier.

By default, the account role used to create the instance can call this method.

Note that operating on any object in a schema also requires the USAGE privilege on the parent database and 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.

Usage notes

Call the method in a separate SQL statement (no method chaining).

Examples

Delete a category from the medical_codes instance:

CALL medical_codes!DELETE_CATEGORY('IC_10_CODES');
Copy

Returns:

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