drop_network

Drops an existing network.

If the cascade option is used then any nodes associated with the network will be dropped too; otherwise the drop will fail if the network contains any nodes.

Available in the star$administration database and requires the star$administration role.

Parameters:

Name	Optional	Type	Description
network$	Mandatory	Text	The name of the network to be dropped.
cascade$	Mandatory	Boolean	Indicates if nodes should be dropped too.

Examples:

SELECT drop_network('mynetwork',true); -- drops a network called 'mynetwork'.

SELECT drop_network('mynetwork',false); -- drops an empty network.

Tips:

• The star$networks view indicates which networks exist.