Append Method (ADOX Indexes)

Microsoft ActiveX Data Objects (ADO)

Append Method (Indexes)

       

Adds a new Index object to the Indexes collection.

Syntax

Indexes.Append Index [, Columns]

Parameters

Index   The Index object to append or the name of the index to create and append.

Columns   Optional. A Variant value that specifies the name(s) of the column(s) to be indexed. The Columns parameter corresponds to the value(s) of the Name property of a Column object or objects.

Remarks

The Columns parameter can take either the name of a column or an array of column names.

An error will occur if the provider does not support creating indexes.