Show TOC

 Index IdentifiersLocate this document in the navigation structure

The system distinguishes several indexes on the same table by a three-place index identifier. The index identifier must contain only letters and digits. The ID 0 is reserved for the primary index.

The index name on the database adheres to the convention <Table Name>~<IndexID>.

Tip

TEST~A is the name of the corresponding database index in the database for table TEST and the secondary index with ID A.

Note

If the convention for defining the index name in the database has changed several times, it is possible that some of the indexes in the database do not follow this convention.

Indexes can have a 13-place name in the database. The first 10 places (possibly filled with underlining) are for the table names, and the 11th to 13th places are for the three-place index identifier (for example TEST______A).