Columns Collection (ADOX)

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


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.


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.

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)