How the Case Insensitivity Wizard Uses Default Values

The Table Name and Column Name are the only required variables for the Case Insensitivity Wizard. If you omit the other variables, then the Case Insensitivity Wizard uses the defaults that this topic describes.

Default Values for the Method Variable

The Case Insensitivity Wizard uses the following default values for the method variable:

• If the Force Case property is set on the table column, then the wizard uses the Force Case method.

• If the Force Case property is not set on the table column, then the wizard uses the Database method.

Default Values for the Index Strategy Variable

The Case Insensitivity Wizard uses the following defaults for the index strategy variable:

• If the method is Force Case, then the wizard sets the index strategy to None.

• If the method is Database, and if the base column does not contain an index, then the wizard sets the index strategy to None.

• If the method is Database, and if the base column contains an index, then the wizard uses the Copy All index strategy.

If the Case Insensitivity Wizard uses None as an index strategy, then the wizard does not define new columns or indexes. It sets the Default Insensitivity property to DB Case & Accent.

The Case Insensitivity Wizard runs the following default logic:

• If the Force Case property is set on a column, then the wizard does not define columns or indexes.

• If the column contains an index, then the wizard does not define columns or indexes.

In these situations, the Case Insensitivity Wizard accepts the column as eligible but does not define columns or indexes. These default behaviors define implicit eligibility requirements.

Default Values for the Operation Variable

If you do not include the Operation variable, then the Case Insensitivity Wizard sets Operation to On, regardless of the method or index strategy.