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.
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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho