DROP RULE

Removes a rewrite rule.

Synopsis

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

Description

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

Parameters

• 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.

Examples

Remove the rewrite rule sales_2006 on the table sales:

DROP RULE sales_2006 ON sales;

Compatibility

DROP RULE is a Greenplum Database language extension, as is the entire query rewrite system.

See Also

ALTER RULE, CREATE RULE