EPUB | CHM | PDF

TMySQLTable.Methods.CreateTable

Top Previous Next

Builds a new table using new structure information.

Syntax:

procedure CreateTable;

Description:

Call CreateTable at runtime to create a table using this dataset's current definitions. If the table already exists, CreateTable overwrites the table's structure and data. To avoid overwriting an existing table, check the Exists property before calling CreateTable.

If the FieldDefs property contains values, these values are used to create field definitions. Otherwise the Fields property is used. One or both of these properties must contain values in order to create a database table.

If the IndexDefs property contain values, these values are used to create indexes on the table.

See also: Exists, FieldDefs, IndexDefs properties, CreateTable usage example