Synchronize Next Keys

Use this utility to synchronize the NextKeys table with the contents of the database tables that contain the key values. Synchronize Next Keys rebuilds only from local site data.

Note:  To prevent blocking, this utility should be run only when no other users are logged into the application database.

The grid on this form contains this information for each alphanumeric key that can have a prefix:

  • The "Full Column" name, which is the clustered key table and column name. This takes the form of TableName.ColumnName
  • The names of the Table and Column where the key resides
  • The value of Sub Key column
  • Any Prefix used with the key
  • The Last Value used with that Prefix and Sub Key combination at the local site.

You can also use this form to perform these actions:

  • Access the Next Key Definitions form to define Next Key metadata for new tables and columns.
  • Purge extra Next Keys data.