Show TOC

Rebuilding ReferencesLocate this document in the navigation structure

You can rebuild references at any time to create default references between PK columns in one table and columns with identical code and data type in another table. Rebuilding is not possible between two tables with PK columns. Rebuilding references can be useful following the reverse engineering of a database in which not all the references could be reverse engineered.

Procedure

  1. Select Start of the navigation path Tools Next navigation step Rebuild Objects Next navigation step Rebuild References End of the navigation path, and specify 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.
  2. [optional] Click the Selection tab to specify which tables you want to rebuild references for. By default, all tables are selected.

    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 tool next to the list, and then select a sub-package from the dropdown list.

  3. 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.