Red Brick Warehouse Extended Attributes

The following extended attributes are defined by default in the Red Brick Warehouse DBMS.

Columns

The following extended attributes are available on the Red Brick tab:

Name

Description

Unique

Declares 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 extended attributes are available on the Red Brick tab:

Name

Description

Macro Type

A macro can be temporary, public, or private: see MacroTypeList for details.

If neither temporary nor public is specified, a private macro is created by default.

Scripting name: MacroType