system.indexes

Advantage SQL Engine

Contains one row for each index in the database.

Field Name

Field Type

Field Size

Description

Name

Character

200

Index name.

Parent

Character

200

The name of the table the index was created on.

Index_File_Name

Character

200

The name of the index file where the index is located.

Index_Expression

Character

510

The expression used to build the index.

Index_Condition

Character

510

The conditional expression used to build the index.

Index_Options

Integer

4

Numerical representation of the index options.

Index_Key_Length

Integer

4

The length of the index key.

Index_FTS_Min_Length

Integer

4

The minimum length of a word for it to be included in an FTS Index.

Index_FTS_Delimiters

Memo

Variable

The delimiters used in parsing the table for the FTS index.

Index_FTS_Noise

Memo

Variable

List of all noise words excluded from the FTS index.

Index_FTS_Drop_Chars

Memo

Variable

The list of characters that are dropped (ignored) unconditionally.

Index_FTS_Conditional_Chars

Memo

Variable

The list of characters that are dropped (ignored) when they are on the beginning or end of a word.

Comment

Memo

Variable

The dictionary description of the index order.