Relationships and Domains › Relationships in the Physical Model › Migrate a Partial Key in the Physical Model

Migrate a Partial Key in the 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. Follow these steps to migrate a partial key in the physical model:

1. Ensure you are in the logical display of a logical/physical model, right-click the entity that corresponds to the selected table, and then click Attributes to open the Attributes dialog.
2. Click the General tab.
3. Select an attribute from the Attribute list that corresponds to a column you want to hide.
4. Select the Logical Only check box.
5. Repeat Steps 3 and 4 for each attribute or column that you want to hide in the physical model.
6. Click OK to save your changes and close the Attributes dialog.