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_DESIGN ( 'design‑name' [, force‑drop ] )
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
Superuser, or design creator
The following example deletes the Database Designer design
VMART_DESIGN and all its contents:
=> SELECT DESIGNER_DROP_DESIGN ('VMART_DESIGN');