Columns Collection

 

Description

 

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.

 

Valid XHTML 1.0 Transitional