DROP ROUTING RULE

Deletes a routing rule from the catalog.

Deletes a routing rule from the catalog.

Syntax

DROP ROUTING RULE [ IF EXISTS ] rule‑name

Parameters

`IF EXISTS`: Specifies not to report an error if the routing rule to drop does not exist. Use this clause in SQL scripts to avoid errors on dropping non-existent objects before attempting to create them.
rule‑name: Name of the rule to drop.

Privileges

Superuser

Examples

=> DROP ROUTING RULE internal_clients;
DROP ROUTING RULE