Rebuilding References

You can rebuild references to create default references between PK columns in one table and columns with identical code and data type in another table. Note that rebuilding is not possible between two tables with PK columns.

Rebuilding references is useful following the reverse engineering of a database in which all of the references could not be reverse engineered.

  1. Select Tools > Rebuild Objects > Rebuild References to open the Rebuild References dialog box.
  2. Select a mode:
    • Delete and Rebuild - All existing references are deleted, and new references built based on matching key columns

    • Preserve - All existing references are kept, and new references are built based on new matching key columns

  3. [optional] Click the Selection tab and specify the tables for which you want to rebuild references. By default, all tables are selected.


    Note:

    To rebuild references between tables in a package, select the package from the list at the top of the tab.

    To rebuild references between tables in a sub-package, select the Include Sub-Packages icon next to the list, and then select a sub-package from the dropdown list.

  4. Click OK. If you selected the Delete and Rebuild mode, a confirmation box asks you to confirm your choice. Click Yes to confirm the deletion and rebuild of the selected references.