---
name: "drop_rule"
section: "7"
platform: "linux"
package: "postgresql"
version: "7.4.7-6sarge6"
release: "Debian 3.1 (Sarge)"
platforms: ["linux"]
url: "https://new.carta.tech/drop_rule"
---

# drop\_rule(7)

remove a rewrite rule

## NAME

DROP RULE - remove a rewrite rule

## SYNOPSIS

```
DROP RULE name ON relation [ CASCADE | RESTRICT ]

```

## DESCRIPTION

**DROP RULE** drops a rewrite rule.

## PARAMETERS

- *name*

  The name of the rule to drop.

- *relation*

  The name (optionally schema-qualified) of the table or view that the rule applies to.

- **CASCADE**

  Automatically drop objects that depend on the rule.

- **RESTRICT**

  Refuse to drop the rule if any objects depend on it. This is the default.

## EXAMPLES

To drop the rewrite rule newrule:

```
DROP RULE newrule ON mytable;

```

## COMPATIBILITY

There is no **DROP RULE** statement in the SQL standard.

## SEE ALSO

CREATE RULE \[[**create\_rule**(7)](/create_rule/7.md)\]