DROP RULE v6.27.4

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 WarehousePG language extension, as is the entire query rewrite system.

See Also

ALTER RULE, CREATE RULE

Parent topic: SQL Commands