columns-collection-adox.md

title	Columns Collection (ADOX) | 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	Index::Columns Table::Columns Key::Columns Columns
helpviewer_keywords	Columns collection [ADOX]
ms.assetid	23b9fea8-4f76-4a51-95ce-1a6ce4560b34
author	MightyPen
ms.author	genemi

Columns Collection (ADOX)

Contains all Column objects of a table, index, or key.

Remarks

The Append method for a Columns collection is unique for ADOX. You can:

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

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

• Access a column in the collection with the Item property.

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

• Remove a column from the collection with the Delete method.

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

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 that is already appended to the Tables collection.

This section contains the following topic.

• Columns Collection Properties, Methods, and Events

See Also

Columns and Tables Append Methods, Name Property Example (VB)
Connection Close Method, Table Type Property Example (VB)
Keys Append Method, Key Type, RelatedColumn, RelatedTable and UpdateRule Properties Example (VB)
ParentCatalog Property Example (VB)
SortOrder Property Example (VB)
Column Object (ADOX)