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)