DROP MASKING POLICY

Drops a dynamic data masking policy from all databases. You can't drop a masking policy that's still attached to one or more tables. For more information on dynamic data masking, see Dynamic data masking.

Superusers and users or roles that have the sys:secadmin role can drop a masking policy.

Syntax

DROP MASKING POLICY policy_name;

Parameters