Index naming convention

New index names use the following pattern:
  • tableName_type_leadingColumn_hash
These variables have the following meanings.
Variable Meaning
tableName Name of the database table, up to 10 characters
type Single character that describes the type of index, allowed values include:
  • N - Non-unique index
  • S - Spatial index
  • S - Unique index
leadingColumn Index leading column name, up to 10 characters
hash Hash code, 13 characters

The longest that a name can be under this scheme is 37 characters.

For example, for a unique index on pc_accountcontactrole for the columns [ACCOUNTCONTACT, RETIRED, SUBTYPE] the index name becomes:
  • ACCOUNTCON_U_ACCOUNTCON_1M5F4WQOIDN21

For the primary key index, the name remains as PK_tableName.