ALTER MASK statement
The ALTER MASK statement defines the changes to a column mask.
ALTER MASK schema.maskName | This option specifies the name of the column mask to change. | ||||||
|---|---|---|---|---|---|---|---|
SCHEMA newSchema | This option specifies the name of the new schema to which the column mask belongs. | ||||||
NAME newName | This option specifies the new name of the column mask. | ||||||
ENABLE | This option makes the column mask operative for column access control on the table. ENABLE value parameters
| ||||||
COMMENT 'newCommentString' | This option updates the column mask comment. | ||||||
COLUMN newColName | This option changes the column to which the mask applies. newColName must be an unqualified name that identifies a column of the specified table. | ||||||
TBCORRELATION newTableCorrelation | This option changes the correlation name for the table associated with the column mask. | ||||||
MASKTEXT(newMaskText) | This option updates the CASE expression that determines the value returned for the column. | ||||||
PATH (schemaList) | This option specifies the path for the mask. |
Related topics