Categories:
User & Security DDL (Network Policies)

DROP NETWORK POLICY

Removes the specified network policy from the system.

Note

Only security administrators (i.e. users with the SECURITYADMIN role) can drop network policies.

See also:

CREATE NETWORK POLICY , SHOW NETWORK POLICIES

ALTER ACCOUNT

Syntax

DROP NETWORK POLICY [ IF EXISTS ] <name>

Parameters

name
Specifies the identifier for the network policy to drop. If the identifier contains spaces or special characters, the entire string must be enclosed in double quotes. Identifiers enclosed in double quotes are also case-sensitive.

Usage Notes

  • Dropped network policies cannot be recovered; they must be recreated.
  • A network policy can be dropped even if it is currently associated with an account.

Examples

Drop a network policy named mypolicy:

DROP NETWORK POLICY mypolicy;