REDACTION_COLUMNS

REDACTION_COLUMNS displays information about all redaction columns in the current database.

**Table 1** **REDACTION_COLUMNS** columns
Name	Type	Description
object_schema	name	Redacted object schema.
object_owner	Name	Redacted object owner.
object_name	Name	Redacted object name.
column_name	Name	Redacted column name.
function_type	Integer	Redaction type.
function_parameters	Text	Parameter used when the redaction type is partial (reserved).
regexp_pattern	Text	Pattern string when the redaction type is regexp (reserved).
regexp_replace_string	Text	Replacement string when the redaction type is regexp (reserved).
regexp_position	Integer	Start and end replacement positions when the redaction type is regexp (reserved).
regexp_occurrence	Integer	Replacement times when the redaction type is regexp (reserved).
regexp_match_parameter	Text	Regular control parameter used when the redaction type is regexp (reserved).
function_info	Text	Redaction function information.
column_description	Text	Description of the redacted column.
inherited	Bool	Whether a redacted column is inherited from another redacted column.
policy_name	Name	Name of the data masking policy. This parameter is supported only by clusters of version 8.2.1.100 or later.

Parent Topic: System Views

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.