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
- Select , 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.
- [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.
- 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.