How the Case Insensitivity Wizard Limits the Length of An Object Name

The default length for a column name or index name is 30 characters. If a CIAI column name or index name exceeds the maximum length, then the Case Insensitivity Wizard does the following:

• Truncates the column base name for a column name

• Truncates the table base name for an index name

The wizard does the following:

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

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

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

The Case Insensitivity Wizard does not truncate a prefix or a suffix.

You can manually limit the length of schema object names to 18 characters. For more information, see Limiting the Length of Schema Object Names Manually.

How the Case Insensitivity Wizard Makes Sure Each Name Is Unique

If the Case Insensitivity Wizard truncates a column or index name, then the name might not be unique. If this situation occurs, then the wizard truncates the farthest character in the base column name or base table name. The wizard replaces the truncated character with an integer, starting with 1. To maintain the overall string length, the wizard does the following:

• Increments the integer if the truncated name is not unique

• Truncates the name to make room for more digits if the wizard requires more digits to make the name unique