DESIGNER_CREATE_DESIGN

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

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:

• 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)

See also