Работа с индексами

Each function listed below returns information about an index or indexes, or performs a task that affects an index, such as dropping it, deleting it, or adding it.

DbiAddIndex:
Creates an index on an existing table.
DbiCloseIndex:
Closes the specified index on a cursor.
DbiCompareKeys:
Compares two key values based on the current index of the cursor.
DbiDeleteIndex:
Drops an index on a table.
DbiExtractKey:
Retrieves the key value for the current record of the given cursor or from the supplied record buffer.
DbiGetIndexDesc:
Retrieves the properties of the given index associated with the cursor.
DbiGetIndexDescs:
Retrieves index properties.
DbiGetIndexForField:
Returns the description of any useful index on the specified field.
DbiGetIndexSeqNo:
Retrieves the ordinal number of the index in the index list of the specified cursor.
DbiGetIndexTypeDesc:
Retrieves a description of the index type.
DbiOpenIndex:
Opens the index for the table associated with the cursor.
DbiRegenIndex:
Regenerates an index to make sure that it is up-to-date (all records currently in the table
are included in the index and are in the index order).
DbiRegenIndexes:
Regenerates all out-of-date indexes on a given table.
DbiSwitchToIndex:
Allows the user to change the active index order of the given cursor.
Взято с Delphi Knowledge Base: http://www.baltsoft.com/

Отправить комментарий

Проверка
Антиспам проверка
Image CAPTCHA
...