> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cockroachlabs.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DROP POLICY

The `DROP POLICY` statement removes an existing [row-level security (RLS)](/docs/stable/enum.md) policy from a table.

## Syntax

```
DROP POLICY [ IF EXISTS ] policy_name ON table_name [ CASCADE | RESTRICT ];
```

## Parameters

| Parameter | Description |
| - | - |
| `policy_name` | Unique identifier for the policy on the table. |
| `table_name` | The table to which the policy applies. |
| `IF EXISTS` | Suppresses an error if the policy doesn't exist. |
| `CASCADE, RESTRICT` | Standard dependency handling (not relevant for policies themselves). |

## Examples

### Drop a policy

To drop an existing policy, issue the following statement:

```sql theme={"theme":{"light":"catppuccin-mocha","dark":"catppuccin-mocha"}}
DROP POLICY IF EXISTS your_policy ON orders;
```

## See also

* [Row-level security (RLS) overview](/docs/stable/row-level-security.md)
* [`CREATE POLICY`](/docs/stable/create-policy)
* [`ALTER POLICY`](/docs/stable/alter-policy)
* [`SHOW POLICIES`](/docs/stable/show-policies)
* [`ALTER TABLE ... ENABLE ROW LEVEL SECURITY`](/docs/stable/alter-table#enable-row-level-security)
* [`ALTER ROLE ... WITH BYPASSRLS`](/docs/stable/alter-role#allow-a-role-to-bypass-row-level-security-rls)
* [`CREATE ROLE ... WITH BYPASSRLS`](/docs/stable/create-role#create-a-role-that-can-bypass-row-level-security-rls)