Specifying the Indexes to Create Example

Top

The TABSTable.IndexDefs property is used to specify which indexes to be defined for the new table. The IndexDefs property is an array of TIndexDef objects, each of them containing information about the index to create. You may add new TIndexDef objects using the Add method of the TIndexDefs object contained in the IndexDefs property. The Add method accepts the following parameters for the index being defined:

Index Name (String)	Index Name parameter contains the name to be given to the index.
Fields List (String)	Fields List parameter contains the list of fields to be included into the index. Multiple field names specified in this parameter should be separated with a semicolon (;).
Index Options (TIndexOptions)	Index Options parameter provides information about the type of index being created (please see the supported TIndexOption options).