Forward Engineer/Alter Script › Filter Dangling Relationships from the Schema

Filter Dangling Relationships from the Schema

You can filter dangling relationships from the schema.

To filter dangling relationships from the schema

  1. Click Create Subject Areas in the active model, to open the Subject Areas dialog.
  2. Select the Filter Dangling Relationships from Schema Gen check box.
  3. Click OK.

    You are returned to the diagram window.

  4. When you are ready to generate the schema, choose Forward Engineer/Schema Generation on the Tools menu.
  5. Click Generate in the Schema Generation Report dialog to generate the schema. Only the objects in the current subject area are references when you generate the schema statements that relate to foreign keys and triggers.

Note: When you select the Filter Dangling Relationship from Schema Gen option, attributes that migrate from tables outside of the subject area are still shown as foreign keys. This option has no effect on the graphical objects in the model, only the schema statements change.