Table Object (ADOX)
Represents a database table including columns, indexes, and keys.
The following code creates a new Table:
Dim obj As New Table
With the properties and collections of a Table object, you can:
Identify the table with the Name Property (ADOX) property.
Determine the type of table with the Type Property (Table) (ADOX) property.
Access the database columns of the table with the Columns Collection (ADOX) collection.
Access the indexes of the table with the Indexes Collection (ADOX).
Access the keys of the table with the Keys Collection (ADOX).
Specify the Catalog that owns the table with the ParentCatalog Property (ADOX) property.
Return date information with the DateCreated Property (ADOX) and DateModified Property (ADOX) properties.
Access provider-specific table properties with the Properties Collection (ADO) collection.
Your data provider may not support all properties of Table objects. An error will occur if you have set a value for a property that the provider does not support. For new Table objects, the error will occur when the object is appended to the collection. For existing objects, the error will occur when setting the property.
When creating Table objects, the existence of an appropriate default value for an optional property does not guarantee that your provider supports the property. For more information about which properties your provider supports, see your provider documentation.
This section contains the following topic.
Catalog ActiveConnection Property Example (VB)
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)
Columns Collection (ADOX)
Indexes Collection (ADOX)
Keys Collection (ADOX)
Properties Collection (ADO)
Tables Collection (ADOX)