DESIGNER_CREATE_DESIGN
Creates a design with the specified name.
Behavior Type
Syntax
DESIGNER_CREATE_DESIGN ( 'design‑name' )
Parameters
| design‑name |
Name of the design to create, can contain only alphanumeric and underscore (_) characters. Two users cannot have designs with the same name at the same time. |
Privileges
- Superuser
- DBDUSER with WRITE privileges on storage location of design‑name.
Database Designer System Views
If any of the following V_MONITOR tables do not already exist from previous designs, DESIGNER_CREATE_DESIGN creates them:
DESIGNSDESIGN_TABLESDEPLOYMENT_PROJECTIONSDEPLOYMENT_PROJECTION_STATEMENTSDESIGN_QUERIESOUTPUT_DEPLOYMENT_STATUSOUTPUT_EVENT_HISTORY
Examples
The following example creates the design VMART_DESIGN:
=> SELECT DESIGNER_CREATE_DESIGN('VMART_DESIGN');
DESIGNER_CREATE_DESIGN
------------------------
0
(1 row)