Garpen
New User
Joined: 03 Jan 2007
Posts: 14
Location: Sweden
|
|
|
|
Whether the index is unique:
D No (duplicates are allowed)
U Yes
P Yes, and it is a primary index (As in prior releases of DB2, a value of P is used for primary keys that are used to enforce a referential constraint.)
C Yes, and it is an index used to enforce UNIQUE constraint
N Yes, and it is defined with UNIQUE WHERE NOT NULL
R Yes, and it is an index used to enforce the uniqueness of a non-primary parent key
G Yes, and it is an index used to enforce the uniqueness of values in a column defined as ROWID GENERATED BY DEFAULT. |
|
