DESIGNER_CREATE_DESIGN
Creates a design with the specified name.
Creates a design with the specified name.
This is a meta-function. You must call meta-functions in a top-level SELECT statement.
Behavior type
VolatileSyntax
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:
-
DESIGNS -
DESIGN_TABLES -
DEPLOYMENT_PROJECTIONS -
DEPLOYMENT_PROJECTION_STATEMENTS -
DESIGN_QUERIES -
OUTPUT_DEPLOYMENT_STATUS -
OUTPUT_EVENT_HISTORY
Examples
The following example creates the design VMART_DESIGN:
=> SELECT DESIGNER_CREATE_DESIGN('VMART_DESIGN');
DESIGNER_CREATE_DESIGN
------------------------
0
(1 row)