User & Security DDL (Network Policies)
DROP NETWORK POLICY¶
Removes the specified network policy from the system.
Only security administrators (i.e. users with the SECURITYADMIN role) can drop network policies.
DROP NETWORK POLICY [ IF EXISTS ] <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.
Only the network policy owner (i.e. role with the OWNERSHIP privilege on the network policy) or higher can execute this command.
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.
Drop a network policy named
DROP NETWORK POLICY mypolicy;