drop_schema

Drops an existing database schema. 

Available in a network database and requires the star$define role.

Parameters:

Name	Optional	Type	Description
schema$	Mandatory	Text	The name of the database schema to be dropped.
cascade$	Mandatory	Boolean	Indicates if dependent objects can be dropped.

Examples:

SELECT drop_schema('myschema',true); -- drops schema 'myschema' and dependent objects

SELECT drop_schema('myschema',false); -- drops schema 'myschema' if no dependent objects

Tips:

• The star$schemas view indicates which schemas exist.