Red Brick Warehouse

To create a PDM with support for features specific to the Red Brick Warehouse DBMS family, select the appropriate version in the DBMS field of the New Model dialog. To view these extensions to the PowerDesigner metamodel in the Resource Editor, select Database > Edit Current DBMS and expand the Profile node.

The following sections list the extensions provided for Red Brick Warehouse.

Columns

The following extensions are available on the Red Brick tab:

Name	Description
Unique	Specifies that duplicate values are not allowed in the column. Declaring a column UNIQUE does not enforce uniqueness on the column; to enforce uniqueness, you must also build a BTREE index on the column. Scripting name: IsUnique

Name

Description

Unique

Specifies that duplicate values are not allowed in the column. Declaring a column UNIQUE does not enforce uniqueness on the column; to enforce uniqueness, you must also build a BTREE index on the column.

Scripting name: IsUnique

Procedures

The following extensions are available on the Red Brick tab:

Name	Description
Macro Type	Specifies the type of macro. You can choose either Public or Temporary. If you do not select a type, a private macro is created by default. Scripting name: MacroType

Name

Description

Macro Type

Specifies the type of macro. You can choose either Public or Temporary. If you do not select a type, a private macro is created by default.

Scripting name: MacroType