TableDef Object

Represents an object, describing a database. Controls existing fields and indexes of the table and allows to create new ones. An instance of this object can be retrieved by using the CreateTableDef method of the Database object, or from the TableDefs collection.

Properties

Name The name of the object for indentification in the collection.

Methods

CreateField Creates a new field in the table. Returns a Field object.
CreateIndex Creates a new index in the table. Returns an Index object.
OpenRecordset Reads the entire contents of the table. Returns a Recordset object.
CreateProperty Creates a Property object, that describes a user-defined property.
Fields Provides access to the Fields collection.
Indexes Provides access to the Indexes collection.
Properties Provides access to the Properties collection.

Remarks

New fields and indexes will be added to the table only on calling the Append method of the Fields and Indexes collections respectively.

 

See Also

Database Object, Field Object, Fields Object, Index Object, Indexes Object, Property Object, Properties Object, Recordset Object, TableDefs Object, Append Method, CreateTableDef.