Keys valid

This rule checks whether any of the table's key values have leading or trailing white space, and that all keys are uppercase.

The check includes:

• the primary key (unique identifier), such as EmployeeCode on the Employee table.
• all foreign keys, such as AwardCode on the Employee table.

This rule runs for every table that you have selected, but only checks a specific subset of columns that have been identified as unique identifiers or foreign keys, are of type "string", and are utilised by the regen framework.

This rule supports a basic correction that you can specify with the Correction Action option:

• "LogOnly" performs no correction.
• "RemoveForeignKeyLeadingAndTrailingSpaces" removes any leading and trailing white space from foreign keys, provided the changes can be made safely.

The first time that you use this rule, you should use the "LogOnly" option. This option allows you to see any problems with your database so that you can check and correct these problems if required.

How do I change the CorrectionAction?
1. On the Select the rules to use during integrity checking page, click the Keys valid rule.
2. In the Options for rule section, select CorrectionAction = "LogOnly".

Values are modified only when a foreign key is invalid. Unique identifiers cannot be updated in this manner.

For more information about correcting these errors, see Fix key invalid errors.

Topic: 9059