Previous Topic: Subtype Relationships in the Physical ModelNext Topic: Migrate a Partial Key in the Physical Model


Partial Key Migration

Partial key migration is supported on the physical side of a logical/physical model. The partial key migration feature is implemented by hiding one or more columns that were migrated to a table as foreign key columns. As a result, when you generate your model, each table can include all migrated foreign key columns or any subset of them as you have indicated in the model.

To hide a portion of a migrated foreign key, select the table that contains the columns you want to hide, then switch to the logical model. Right-click the selected table, and then choose Attributes. In the Attributes dialog, you can select each attribute that corresponds to a column you want to hide and select the Logical Only check box.

When you return to the physical model, the selected foreign key columns no longer appear in the selected table.

To reverse partial key migration, return to the logical model and clear the Logical Only check box for the corresponding attribute.