DESIGNER_DROP_ALL_DESIGNS

Removes all Database Designer-related schemas associated with the current user. Use this function to remove database objects after one or more Database Designer sessions complete execution.

Behavior Type

Immutable

Syntax

DESIGNER_DROP_ALL_DESIGNS()

Parameters

None.

Privileges

One of the following:

  • Superuser : Drops all designs.
  • Design creator: Drops all designs created by this user.

Example

The following example removes all schema and their contents associated with the current user. DESIGNER_DROP_ALL_DESIGNS returns the number of designs dropped:

=> SELECT DESIGNER_DROP_ALL_DESIGNS();
 DESIGNER_DROP_ALL_DESIGNS
---------------------------
                         2
(1 row)

See Also