Renaming and refactoring schemas in physical data models

When you rename in physical data models by using the refactoring feature in this product, view references are also updated automatically.
You must have a physical data model stored in a data design project.

In addition to this method, you can also rename schemas by highlighting a schema object in a physical data model and pressing F2 , either from the Data Project Explorer or a data diagram. However, if you use the F2 method, view objects are not automatically updated. Therefore, this is the preferred method for renaming schemas.

To renaming and refactoring schemas in physical data models:

  1. In the Data Project Explorer, expand a physical data model and right-click a schema.
  2. Select Refactor > Rename.
  3. In the window that opens, specify a new name for the schema, and specify whether views that reference this schema should also be updated with the new schema name.
  4. Click OK.
The schema is renamed, and any views that reference the schema are also updated if you specified this option. The changes are visible in the Data Project Explorer and in data diagrams that contain these objects.

Feedback