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.
This section contains the following topic.
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)