Index Object

Represents an index of a database table. An instance of this object can be retrived by using the CreateIndex method of the TableDef object, or from the Indexes collection.

Properties

Name The name of the object for indentification in the collection.
Foreign A flag, indicating whether the index is an external key.
Primary A flag, indicating whether the index is a primary key.
Unique

A flag, indicating whether the given index is unique within the scope of the table, that contains it.

Methods

CreateField Defines an existing table field, on which the given index will be based. Returns a Field object.
CreateProperty Creates a Property object, that describes a user-defined property.
Fields Provides access to the Fields collection.
Properties Provides access to the Properties collection.

Remarks

New fields will be associated with the given index only after the Append method of the Fields collection has been called.

 

See Also

Field Object, Fields Object, Indexes Object, Property Object, Properties Object, TableDef Object, CreateIndex Method