Table object

The Table object allows you define the structure of a table in a catalog. The Tables collection contains all of the tables in a catalog.

Creating a new table

Use the Append method to create a new table. The Append method automatically adds the table to the Tables collection.

{Append a new table named "BuyerInfo" to the Tables collection.}
adoxTable = catalog.Tables.Append("BuyerInfo");

Retrieving an existing table

You can retrieve an existing table from the Tables collection with the Item property by the number associated with the table.

{Retrieve the first table from the catalog.}
adoxTable = catalog.Tables.Item[0];

You can also access the tables by the name of the table.

{Retrieve the table named "BuyerInfo".}
adoxTable = catalog.Tables.Item["BuyerInfo"];

Retrieving and setting the name of a table

Use the Name property to retrieve the name of a table.

{Retrieve the name of a table.}
name = str(adoxTable.Name);

You can also use the Name property to set the name of a table.

{Set the name of a table.}
adoxTable.Name = "BuyerInfo";

Deleting a table

To delete a table from a catalog, use the Delete method. You can delete a table by the number associated with the table.

{Delete the first table from the Tables collection.}
catalog.Tables.Delete(0);

You can also delete a table by the name of the table.

{Delete the table named "BuyerInfo".}
catalog.Tables.Delete("BuyerInfo");


Documentation Feedback