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

# DROP POLICY

export const InternalLink = ({version, path = "", children, ...props}) => {
  let detectedVersion = version || "stable";
  if (typeof window !== 'undefined' && !version) {
    const match = window.location.pathname.match(/\/docs\/([^/]+)/);
    if (match) {
      detectedVersion = match[1];
    }
  }
  const normalizedPath = path.startsWith("/") ? path.slice(1) : path;
  return <a href={`/docs/${detectedVersion}/${normalizedPath}`} {...props}>
      {children}
    </a>;
};

The `DROP POLICY` statement removes an existing <InternalLink path="enum">row-level security (RLS)</InternalLink> policy from a <InternalLink path="schema-design-table">table</InternalLink>.

## 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 <InternalLink path="schema-design-table">table</InternalLink> 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

* <InternalLink path="row-level-security">Row-level security (RLS) overview</InternalLink>
* <InternalLink path="create-policy">`CREATE POLICY`</InternalLink>
* <InternalLink path="alter-policy">`ALTER POLICY`</InternalLink>
* <InternalLink path="show-policies">`SHOW POLICIES`</InternalLink>
* <InternalLink path="alter-table#enable-row-level-security">`ALTER TABLE ... ENABLE ROW LEVEL SECURITY`</InternalLink>
* <InternalLink path="alter-role#allow-a-role-to-bypass-row-level-security-rls">`ALTER ROLE ... WITH BYPASSRLS`</InternalLink>
* <InternalLink path="create-role#create-a-role-that-can-bypass-row-level-security-rls">`CREATE ROLE ... WITH BYPASSRLS`</InternalLink>