table-object-adox.md

title	Table Object (ADOX) | Microsoft Docs
ms.prod	sql
ms.prod_service	connectivity
ms.technology	connectivity
ms.custom
ms.date	01/19/2017
ms.reviewer
ms.topic	conceptual
apitype	COM
f1_keywords	Table
helpviewer_keywords	Table object [ADOX]
ms.assetid	a6d74000-0828-49ba-850a-63da865f8802
author	MightyPen
ms.author	genemi

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:

• 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.

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.

• Table Object Properties, Methods, and Events

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)