A collection of Columns belonging to a Table, used to promote more efficient access to specific records in the Table.

In addition to the common attributes

Returns a list of columns in the Index. Each Column name is preceded by "asc" or "dsc" according to whether that Column is sorted in ascending or descending order.

Access is read/write.

A textual property that gives an overview of the dictionary item.

Access is read/write.

This indicates whether each record in the Table can be uniquely specified by the Index. Possible values are TRUE or FALSE.

Access is read/write.

In addition to the common associations

Relationship to Comments that are applied to the Index.

Multiplicity is 0+, access is read/write.

Relationship to Constraints that are applied to the Index.

Multiplicity is 0+, access is read/write.

A collection of Dictionary Items of type Column.

Multiplicity is 1+, access is read/write.

Relationship to Comments that are owned by the Index.

Multiplicity is 0+, access is read/write.

Relationship to Constraints that are owned by the Index.

Multiplicity is 0+, access is read/write.

A relationship with a Dictionary Item of type Table.

Multiplicity is 1, access is read/write.