Forward Engineer/Alter Script › Dangling Relationships

Dangling Relationships

When you forward engineer or update a database, you can use a subset of the tables in the model. For example, you can generate the schema from a user-defined subject area, which can contain a subset of the tables in the Main Subject Area. You can also use the Table Filter dialog to choose a subset of tables to include when synchronizing or creating a database.

When you work with a subset of the tables in the model, you should account for dangling relationships, which are relationships to tables that are not included in the schema generation or database update. The following options ensure that dangling relationships do not impact data integrity:

• Filtering dangling relationships in the Subject Areas dialog for schema generation.
• Automatic discovery of dangling relationships when synchronizing a model with a database.

More information:

Filter Dangling Relationships from the Schema

Dangling Relationships in Schema Generation

Dangling Relationships in Synchronization