Table Object (ADOX)

Represents a database table including columns, indexes, and keys.

Remarks

The following code creates a new Table:

Dim obj As New Table

With the properties and collections of a Table object, you can:

Note

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.

See Also

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)