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.
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. |
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. |
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 |