Index (automation interface)
A collection of Columns belonging to a Table, used to promote more efficient access to specific records in the Table.
ATTRIBUTES:
In addition to the common attributes
Col Order
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.
Description
A textual property that gives an overview of the dictionary item.
Access is read/write.
Is Unique
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.
ASSOCIATIONS:
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.
Was this helpful?