DESIGNER_DROP_DESIGN

Removes the schema associated with the specified design and all its contents. Use DESIGNER_DROP_DESIGN after a Database Designer design or deployment completes successfully. You must also use it to drop a design before creating another one under the same name.

To drop all designs that you created, use DESIGNER_DROP_ALL_DESIGNS.

Behavior Type

Immutable

Syntax

DESIGNER_DROP_DESIGN ( 'design‑name' [, force‑drop ] )

Parameters

design‑name

Name of the design to drop.

force‑drop Boolean that overrides any dependencies that otherwise prevent Vertica from executing this function—for example, the design is in use or is currently being deployed. If you omit this parameter, Vertica sets it to false.

Privileges

Superuser, or design creator

Example

The following example deletes the Database Designer design VMART_DESIGN and all its contents:

=> SELECT DESIGNER_DROP_DESIGN ('VMART_DESIGN');

See Also

Running Database Designer Programmatically