Restructuring tables is executed by means of the RestructureTable method of the TACRTable component. The properties used by the RestructureTable method include the RestructureFieldDefs and RestructureIndexDefs properties.
Field Name parameter indicates the name to be given to the field.
Size parameter indicates the size of the field. This should be specified for the String type only. For all other data types this parameter should be set as 0. For the String type this parameter indicates the length of the field.
Required parameter indicates whether or not the new field should be required (not Null) while adding or modifying records.
Index Name parameter contains the name to be given to the index.
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 parameter provides information about the type of index being created (please see the component reference supplied with Accuracer for more information on the available TIndexOption options).