DROP RULE

Contents

Removes a rewrite rule.

DROP RULE [IF EXISTS] <name> ON <table_name> [CASCADE | RESTRICT]

Description

DROP RULE drops a rewrite rule from a table or view.

Parameter	Description
IF EXISTS	Do not throw an error if the rule does not exist. A notice is issued in this case
name	The name of the rule to remove
table_name	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

Parameter

Description

IF EXISTS

Do not throw an error if the rule does not exist. A notice is issued in this case

name

The name of the rule to remove

table_name

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

Remove the sales_2026 rewrite rule on the sales table:

DROP RULE sales_2026 ON sales;

DROP RULE is a Greengage DB extension.