Field

Type

Description

iId

UINT16

Specifies the ID of the index type.

szName

DBINAME

Specifies the symbolic name of the index type.

szText

DBINAME

Descriptive text.

szFormat

DBINAME

Optional. Information only about the format (for example, BTREE, HASH).

bComposite

BOOL

If TRUE, supports composite keys.

bPrimary

BOOL

If TRUE, this index type supports a primary index.

bUnique

BOOL

If TRUE, this index type supports unique indexes.

bKeyDescending

BOOL

If TRUE, the key can be descending.

bFldDescending

BOOL

If TRUE, the key can be descending at the field level.

bMaintained

BOOL

If TRUE, this index type supports the maintained option.

bSubset

BOOL

If TRUE, this index type supports the subset expression (dBASE and FoxPro only).

bKeyExpr

BOOL

If TRUE, the key can be an expression (dBASE and FoxPro only).

bCaseInsensitive

BOOL

If TRUE, this index type supports case-insensitive keys.