DESIGNER_RESET_DESIGN
Discards all run-specific information of the previous Database Designer build or deployment of the specified design but keeps its configuration. You can make changes to the design as needed, for example, by changing parameters or adding additional tables and/or queries, before running the design again.
Behavior Type
Syntax
DESIGNER_RESET_DESIGN ( 'design‑name' )
Parameters
| design‑name |
Name of the design to reset. |
Privileges
Non-superuser: design creator
Example
The following example resets the Database Designer design VMART_DESIGN:
=> SELECT DESIGNER_RESET_DESIGN ('VMART_DESIGN');