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:

Have more questions? Submit a request

Comments

Article is closed for comments.

Powered by Zendesk