Turn off automatic key migration

If columns are being added to parent tables when you add a new foreign key, turn automatic key migration off to eliminate this behavior.
Symptoms
Key migration is on by default.
Resolving the problem
To turn off automatic key migration, complete the following steps:
  1. From the main menu, click Windows > Preferences.
  2. Drill down through Data Management and expand Key Migration.
  3. Double-click On Add.
  4. Clear the Migrate key automatically check box, click Apply, and then click OK.

Feedback