Indexes Collection (ADOX)

Microsoft ActiveX Data Objects (ADO)

Indexes Collection

           

Contains all Index objects of a table.



Remarks

The Append method for an Indexes collection is unique for ADOX. You can:

  • Add a new index to the collection with the Append method.

The remaining properties and methods are standard to ADO collections. You can:

  • Access an index in the collection with the Item property.

  • Return the number of indexes contained in the collection with the Count property.

  • Remove an index from the collection with the Delete method.

  • Update the objects in the collection to reflect the current database's schema with the Refresh method.