Vertica Analytics Platform Version 10.0.x Documentation

DROP ROUTING RULE

Deletes a routing rule from the catalog. Dropping the routing rule

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