del_="schema"

<do action_="sql" del_="schema" objname_="[SCHEMA]"/> deletes a schema from the catalog.

Description

del_="schema" deletes the specified schema, alog with all its associated tables and other objects. del_="schema" should be considered an irreversible operation. This transaction signals an error unless the caller has the drop_schema SQL privilege, with one exception: with the weaker drop_self_schema privilege, a user named foo may call the transaction with objname_="self_foo".

Syntax

<dynamic>
    <do action_="sql" del_="schema"
     objname_="[SCHEMA]"/>
</dynamic>

Attributes for del_="schema"

objname_
The name of the schema to delete from the catalog, along with all its associated tables and other objects.