TableDefs Collection

Description

A TableDefs collection contains all stored TableDef objects in a database (Microsoft Jet workspaces only).

Remarks

You manipulate a table definition using a TableDef object and its methods and properties.

The default collection of a Database object is the TableDefs collection.

To refer to a TableDef object in a collection by its ordinal number or by its Name property setting, use any of the following syntax forms:

TableDefs(0)

TableDefs("name")

TableDefs![name]

Properties

Count property.

Methods

Append method, Delete method, Refresh method.

Specifics (Microsoft Access)

See the TableDef object specifics (Microsoft Access).

Example

See the TableDef object example.

Example (Microsoft Access)

See the TableDef object example (Microsoft Access).