Versions Compared

Old Version 1

changes.mady.by.user SRP Support

Saved on

compared with

New Version Current

changes.mady.by.user SRP Support

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ParameterDescription
indextype

The value of this parameter specifies the type of index you create.

ValueDescription
1Btree.
2Cross Reference.
3Relational.
tablenameThe name of the table to index.
columnnameThe name of the column to index.
casemode

The case sensitivity of the index.

ValueDescription
0Creates an index that is not case-sensitive. All values are converted to uppercase in the index.
1Creates a case-sensitive index. No case conversion is applied. Uppercase values saved to the index are stored in uppercase, and lowercase values saved to the index are stored in lowercase.
createmode

Specifies whether to build the indexes immediately or process them at a later time.

ValueDescription
0Build the index at a later time, using the Update_Index stored procedure.
1Build the index immediately.

See Also

Cross Reference indexes, Relational indexes, Btree indexes

Example

The following examples show how to create indexes, programmatically.

...