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.

See Also

Indexes Append Method Example (VB)

Append Method (Columns) | Append Method (Groups) | Append Method (Keys) | Append Method (Procedures) | Append Method (Tables) | Append Method (Users) | Append Method (Views)

Applies To: Indexes Collection