1. Database Upgrade Guide
  2. Column and Index Naming Convention

Column and Index Naming Convention

The Case Insensitivity Wizard uses the same naming conventions as the Siebel Enterprise Integration Manager Wizard when creating CIAI column names and index names. The naming conventions used by the wizard are fixed and cannot be overridden.

Column Names

The Case Insensitivity Wizard defines CIAI column names by appending _CI to the parent column name. For example, if the parent column is LAST_NAME, then the CIAI column would be LAST_NAME_CI.

Index Names

The Case Insensitivity Wizard defines CIAI index names by adding a string to the base table name:

base_table_name_C#

In this table name, # is an integer incremented starting at 1 as needed to create a unique name.

An example of a CIAI index created on table S_CON_ADDR is S_CON_ADDR_C1.

Truncating Names

The default length for column names and index names is 30 characters. You can limit the length of names to 18 characters (to conform to the requirements of IBM DB2), prior to running the CIAI, by selecting the "Limit schema object names to 18 characters" option by navigating to Tools, View, Options, and then Database.

If CIAI column names or index names exceed the maximum length, then the Case Insensitivity Wizard truncates the column base name or the table base name (for indexes) using the following strategy:

  • Deletes underscores one at a time, beginning with the first underscore.

  • Deletes vowels one at a time, beginning with the last vowel.

  • Deletes characters (letters, numbers, and so on) one at a time, beginning with the last character.

The Case Insensitivity Wizard does not truncate prefixes or postfixes.

Column and Index Name Uniqueness

After truncating a column or index name, the name might not be unique. When this occurs, the Case Insensitivity Wizard modifies the truncated column or index name by truncating the last character in the base column name or base table name. The wizard replaces the truncated character with an integer, starting at 1.

If this modification does not create a unique name, then the wizard increments the integer. If the integer becomes two digits or larger, then the wizard truncates the name to make room for the digits. This process maintains the overall string length.