DESIGNER_CREATE_DESIGN

Creates a design with the specified name.

Be sure to back up the current design using the function EXPORT_CATALOG before running the Database Designer functions on an existing schema. You must explicitly back up the existing design when using Database Designer programmatically.

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

Behavior Type

Immutable

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

One of the following:

Superuser
DBDUSER

Examples

The following example creates the design VMART_DESIGN:

=> SELECT DESIGNER_CREATE_DESIGN('VMART_DESIGN');
 DESIGNER_CREATE_DESIGN
------------------------
                      0
(1 row)