| title | Append Method (ADOX Indexes) | Microsoft Docs | |
|---|---|---|
| ms.prod | sql | |
| ms.prod_service | connectivity | |
| ms.technology | connectivity | |
| ms.custom | ||
| ms.date | 01/19/2017 | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| apitype | COM | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 6695769f-275b-4b70-81bd-1a5f7d74926c | |
| author | MightyPen | |
| ms.author | genemi |
Adds a new Index object to the Indexes collection.
Indexes.Append Index [,Columns]
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.
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.
Indexes Append Method Example (VB)
Append Method (ADOX Columns)
Append Method (ADOX Groups)
Append Method (ADOX Keys)
Append Method (ADOX Procedures)
Append Method (ADOX Tables)
Append Method (ADOX Users)
Append Method (ADOX Views)