DROP POLICY
Applies to: 
Databricks SQL Databricks Runtime 16.4 and above Unity Catalog only
Deletes a named policy from a securable.
To run this statement, you must have the MANAGE privilege on the target securable. To drop a policy ON METASTORE (Beta), you must be a metastore admin.
Syntax
DROP POLICY policy_name
ON { METASTORE | CATALOG catalog_name | SCHEMA schema_name | TABLE table_name
| { MODEL SERVICE | MODEL PROVIDER SERVICE | MCP SERVICE | AGENT SERVICE | SKILL } securable_name }
Parameters
-
The name of the policy to drop. If the policy does not exist on the securable, Databricks raises POLICY_NOT_FOUND.
-
The name of the catalog on which the policy is defined.
-
The name of the schema on which the policy is defined.
-
The name of the table on which the policy is defined.
-
securable_name
The fully qualified name (
catalog.schema.name) of a supported non-container securable.
Examples
SQL
> DROP POLICY ssn_mask ON CATALOG employees;
> DROP POLICY hide_eu_customers ON SCHEMA prod.customers;