After I create an entity, a message informs me that there are multiple paths for tables in the entity.
First, verify the constraints for each table listed in the message. If the constraints are incorrect, delete the entity. Then, disable or modify the constraints. Then, create the entity.
To verify the constraints, perform the following steps:
Click
View
Constraints
.
On the
Explorer
pane, select a table listed in the message.
On the
Details
pane, select the
Constraints
tab.
Verify if the constraints are correct.
If the constraints are correct, you can ignore the message.
If the constraints are incorrect, you must perform the following steps:
Delete the entity.
Disable or modify the constraints for the tables you want in the entity.
Create the entity.
Repeat steps 4 to 6 for each table listed in the message.
To delete the entity, perform the following steps:
Click
View
Database Archive
.
Right-click the entity.
Select
Delete Entity
.
Click
Delete
to confirm the delete action.
To disable a constraint, perform the following steps:
Click
View
Constraints
.
On the
Explorer
pane, select a table listed in the message.
On the
Details
pane, select the
Constraints
tab.
Click the
Enabled
check box.
If the constraint you are deleting is a self-referential physical constraint, note that this constraint still exists in the source database. After you archive the entity, you must delete this data from the source database.
Click
View
Refresh
.
To modify a constraint, perform the following steps:
Click
View
Constraints
.
On the
Explorer
pane, select a table listed in the message.
On the
Details
pane, select the
Constraints
tab.
Click
Constraint Condition
.
In the text box that appears, specify the rows that apply to the constraint.
Click
View
Refresh
.
To create the entity, perform the following steps: