Table Object

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.
• Determine the type of table with the Type property.
• Access the database columns of the table with the Columns collection.
• Access the indexes of the table with the Indexes collection.
• Access the keys of the table with the Keys collection.
• Specify the Catalog that owns the table with the ParentCatalog property.
• Return date information with the DateCreated and DateModified properties.
• Access provider-specific table properties with the Properties 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.

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)

Properties, Methods, and Events | Columns Collection | Indexes Collection | Keys Collection | Properties Collection | Tables Collection