Chapter 14 DBMS-Specific Features


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 Internal Code Description
Unique IsUnique 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.

Procedures

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

Name Internal Code Description
Macro Type MacroType 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.

 


Copyright (C) 2005. Sybase Inc. All rights reserved.