DESIGNER_SET_DESIGN_TYPE
Specifies whether Database Designer should create a comprehensive or incremental design. DESIGNER_SET_DESIGN_TYPE
stores the design mode in the DESIGNS
table.
If you do not explicitly set a design mode with this function, Database Designer creates a comprehensive design.
Behavior Type
Syntax
DESIGNER_SET_DESIGN_TYPE ( 'design‑name', 'mode' )
Parameters
design‑name |
Name of the target design. |
mode |
Name of the mode that Database Designer should use when designing the database, one of the following:
For more information, see Design Types in the Administrator's Guide. |
Privileges
One of the following:
- Superuser
- Design creator
Notes
Incremental designs always inherit the K-safety value of the database.
Examples
The following examples show the two design mode options for the VMART_DESIGN
design:
=> SELECT DESIGNER_SET_DESIGN_TYPE(
'VMART_DESIGN
',
'COMPREHENSIVE');
DESIGNER_SET_DESIGN_TYPE
--------------------------
0
(1 row)
=> SELECT DESIGNER_SET_DESIGN_TYPE(
'VMART_DESIGN
',
'INCREMENTAL');
DESIGNER_SET_DESIGN_TYPE
--------------------------
0
(1 row)