Index naming convention
LN indexes are identified by a sequence number for each table, with the sequence numbers starting from one. Each table has at least one index called the primary index. The SQL Server requires that for each database, all index names within each database must be unique. For this reason, the table name, index number, and the index type are included in the index name. The index type refers to the order, either ascending or descending.
Index names have this format:
I<Table name>_<Index number><Index type>For example, the index name for an LN table with name ttadv999, company 000, index number 1, and index type ascending order is:
- Ittadv999000_1a
When the Multilanguage Application Data feature is enabled for a table or a table has one or more BLOB columns, this additional index is created:
[s|t]<DD Table Name><Company Number>$UUID