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
- policy_name
-
The name of the masking policy to drop.
