Index Object |
Description
Represents an index from a database table.
Remarks
The following code creates a new Index:
DIM pIndex AS ADOXIndex pIndex = NEWCOM "ADOX.Index"
With the properties and collections of an Index object, you can:
Note An error will occur when appending a Column to the Columns collection of an Index if the Column does not exist in a Table object already appended to the Tables collection.
Note Your data provider may not support all properties of Index objects. An error will occur if you have set a value for a property that is not supported by the provider. For new Index objects, the error will occur when the object is appended to the collection. For existing objects, the error will occur when setting the property.
Note When creating Index objects, the existence of an appropriate default value for an optional property does not guarantee that your provider supports the property. For more information about which properties your provider supports, see your provider .
|