EPUB | CHM | PDF

TMySQLTable.Properties.IndexDefs

Top Previous Next

Contains information about the indexes for a table.

property IndexDefs: TIndexDefs;

Description:

IndexDefs is a collection of index definitions, each of which describes an available index for the table. Define the index definitions of a table before calling CreateTable or creating a table at design time.

Ordinarily, an application accesses or specifies indexes at runtime through the IndexFieldNames or IndexFields properties.

If IndexDefs is updated or manually edited, the StoreDefs property becomes True.

note The index definitions in IndexDefs may not always reflect the current indexes available for a table. Before examining IndexDefs, call its Update method to refresh the list.

See also: Example: IndexDefs,Update,Count,Items,IndexName,Fields,Name